This import will create receipts in ASBWorks from an Excel or .csv type file so the sales history can be brought over from another accounting system or if a Journal Entry was done to increase an account’s balance. Receipts will appear in Account Statement and Item Sales Report. Ledger account balances will not be affected and receipts will not show in Make Deposit screen. A combination of items may be imported in one spreadsheet however only one Fundraiser may be affected per import. If Membership type or Inventory tracked Items are imported, the student will have the appropriate discount and inventory will be reduced accordingly.
If Options are to be imported, the format is: Option Name|(pipe character)option choice;
For Example:
Size|S;Color|Gold (no spaces or returns allowed) if importing clothing with Size and Color options.
** The “pipe character” is created by pressing the <Shift> and <\> (back slash) keys simultaneously.