|
 
| |
MP 20, 5 Monthly Invoice Register
Additional Resources
Problem with discrepancy between daily and monthly
Monthly Totals
- Monthly invoice register is a
total of all previous invoice registers run since the last monthly
invoice register.
- Monthly invoice registers CAN be rebuilt if you lose or determine that
you have not run all your daily invoice registers for the period requested.
Important Notes
- It is possible to have more than 30 days of invoice registers in this
total.
- The monthly invoice register does not change any data. Is is
simply a compilation of every daily invoice register run since the last
monthly.
What to do if the monthly does not match your daily sales figure totals
- Add the daily totals again. You have most likely made a math
calculation error with your separate figures.
- See what days are represented in the monthly. Is it 1 period, less
than a period or a period plus additional days added in.
- Look at the figures. Many times the report figures and the
calculated figures are both correct but they are based on different
calculations.
- i.e. your calculations may include taxes and the systems may
separate them
Example of the 2nd to the last page of the Monthly Invoice Register
- Total non-taxable by tax category is listed in the 1st column
- Total taxable sales by tax category is listed in the 1st column
- Total taxes collected (includes all cash & charge taxes) is listed in
the Tax $ column
Report Examples
- Please note that typical Monthly Invoice Registers are 60-80 pages.
Monthly Total By Invoices Page 1
- This page details the following information
- invoice # (of each invoice for the given day),
- Tax code,
- Customer number and name,
- Sales person,
- Location (always 01 unless you are multi-location),
- merchandise, tax and total invoice amount,
- cost of ticket and gross margin totals
Monthly Totals By Customer Page 1
- This report gives the final sales totals by customer.
Final Summary Page
This page is most commonly given to your accountant
- Totals include state tax summaries totals,
- Sales person number and initials along with their monthly sales totals
- Final sales totals for the year
|
