QuickBooks Check Sales Information
The sales update that was imported into QuickBooks contains sales information for that particular shift/day and will post as follows:
- Add/Update customers in the QuickBooks Customer Job list that were added or edited from the Point of Sale.
- Post individual Sales Receipts for all Point Of Sale transactions that had customers assigned to them with item by item information on what was purchased on that transaction.
- Post one summarized Sales Receipt to the CashSales customer in QuickBooks for all transactions processed during that shift that had no customers assigned. This Sales Receipt summarizes all items that were purchased through that shift for any transaction that wasn’t given a customer account attached to it. The reference number for the particular invoice is formatted as the Cash Till number followed by the sequence number. For example, sequence 2 of till 100 would post as 1002.
- Post individual invoices for all Point Of Sale transactions that were tendered using the Customer Account (AR) tendering type as well as the Payment on Account (PA) tendering type.
- Post Tendering Totals by type (cash, VI, MC, etc) to user defined accounts.
The Z report for that shift will be given a sequence number.
Every time a till is reset, the sequence number increases by one.
This sequence number can be used to view transaction by transaction reports through the Point of Sale, as well as resending the sales information to QuickBooks if, for example, the adapter wasn’t opened while the Z report was performed.
To resend a sequence that didn’t get imported yet:
- In AccuPOS Retail Management, go to File Export to Accounting.
- Enter the Sequence number and till number to be sent. Hit OK.
This will send the information into QuickBooks just like it would normally when a till is reset (Step 2 above).
If the ending cash for the shift is either over or short, AccuPOS will still report the total cash that should have been collected.
The Over/Short on the Z report does not transfer to QuickBooks.
To adjust the cash amount before you deposit, create an Over/Short account in QuickBooks and manually transfer the over or short amount into this account by creating a Journal Entry inside QuickBooks.