SMARTSystem Management Training Series
Training Session #17C – Create a QB Invoice Register
Purpose:
This document will outline how to create only an Invoice Register in QuickBooks which is not part of their reporting.
Overview:
The SMARTSystem EOD produces an Invoice Register and after importing sales invoices and credits to QuickBooks we need to produce a QB Invoice Register.
These two Invoice Registers, QuickBooks and SMARTSystem, can be compared to verify totals transferred and recorded in QuickBooks.
Establish Invoice Register in QuickBooks:
Here are the steps to create this report:
- Select from the menu REPORTS > Sales > Sales by Customer Summary
2. Click Customize Report in the upper left corner of the screen:
3. Select the Display Tab and enter the information needed:
a. Dates = Custom
b. Report Basis = Accrual
4. Select the Filters Tab and create a Filter by Transaction Type = Invoice
5. The Header/Footer Tab does not change.
6. The Fonts & Numbers Tab does not change.
7. Create and fine tune this Invoice Register:
8. Click Memorize to change the report name and save it for future use:
Before:
After:
9. Click OK and Click Refresh:
10. You are now ready to use your QuickBooks Invoice Register to compare against your SMARTSystem Invoice Register.
* End of Document *
Problem:
When end of day is run, the Invoice Payment Register is reporting one amount, but it doesn’t match what was brought in to Quick Books. What is happening to cause this?
Changes were made to the sales orders associated with the invoices that were already in Quick Books.
Any changes made to a sales order,will automatically cause the invoice to be updated with the changes. The invoice then gets flagged to be re-exported.
The changes will not be imported to QB because the invoice is already there. The updated invoices are listed on the Invoice Payment Register to let you know that something has changed and that QB needs to be updated manually.