MTS #17 C – Create a QB Invoice Register

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:

1. 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.