Report Settings & Filters
The report can be run for any combination of stores and registers but it will only report on entire register batches. If each register is closed out each day you will not run into any conflicts. But if you leave a register 'open' for multiple days and then try to run this report for just one of those days you will only be shown results for all the days the batch was open.
Running the Report
- Select Stores and Registers
- Select Dates
- Select Register Batches to Include
- Click Run Report
Other Options
More options will let you omit or add sections of this report. Export PDF button will let you save the report to a PDF file.
Overview
The Register Balance Report displays a summary of the activities and payments suitable to post to your accounting system or to give to your accountant. The activity data in the report should balance with your payments data just as the two columns below balance.
|
Register Activity
|
|
Payments & Offsets
|
|
|---|---|---|---|
| Net Sales & Returns | $ 1,851 | Cash | $ 358.25 |
| Gift Card Sales | $ 275.00 | Checks | $ 250.22 |
| Order Deposits | $ 150.00 | Gift Cards | $ 125.00 |
| Sales Tax Collected | $ 148.10 | Store Credits | $ 18.45 |
| Paid In | $ - | Master Card | $ 378.65 |
| Paid Out | $ (5.75) | Visa | $ 875.77 |
| Register Opening Balance | $ 150.00 | Amex | $ 188.10 |
| Over/Short | $ (0.79) | Discover | $ (36.63) |
| Deposit Offsets | $ 410.00 | ||
| Totals | $ 2,567.81 | $ 2,567.81 |
Category Totals
This section displays each of your main inventory and non-inventory categories and provides tax exclusive net Sales ($) which is sales - returns. It also displays the units sold for each category.
Payment Totals
This section displays each payment method and provides total funds collected using that payment. It also displays the number of payments for each method.
Transaction Totals
This section displays tax exclusive totals for the following
| Sales | Total (gross) Sales not including sales tax - also displays number of items sold |
| Returns | Total Returns (shown as negative number) not including sales tax - also shows number of items returned |
| Paid In | Funds Paid into the Register - usually change for Paid Out Purchases or additional change for the cash drawer (like quarters or ones) |
| Paid Out | Funds Paid out of the register - usually petty cash purchases like pens or staples or supplier C.O.D. payments |
Tax Totals
Shows tax exclusive value of taxable and non-taxable sales plus the number of transactions in each category.
Tax Collected
This section displays each of your Tax Rules, the amount of sales tax collected for the rule and the number of transactions to which the rule applied.
Sales Person Totals
Displays the net tax exclusive sales attributed to each sales person plus the number of units sold.
Cashier Totals
Displays the tax inclusive sales attributed to each cashier plus the number of transactions rung.
Customer Credits
Contains data for the following register activities. These activities all increase or decrease your customer liabilities.
| New Gift Card Purchases |
Total value of the Gift Cards sold plus the number of new gift cards sold. This increases your customer liabilities and is added to the Net Credits total. |
| New Store Credits Issued | Total value of Store Credits given to customers in exchange for returned goods - also shows the number of new credits issued. This increases your customer liabilities and is added to the Net Credits total. |
| Gift Cards Redeemed | Total payments using Gift Cards and the number of payments using gift cards.This decreases your customer liabilities and is subtracted from the Net Credits total. This information is repeated in the Payments section. |
| Store Credits Redeemed | Total payments using Store Credits and the number of payments using store credit.This decreases your customer liabilities and is subtracted from the Net Credits total. This information is repeated in the Payments section. |
| Work Order Deposits | Deposits paid by customers for orders that have not been completed or delivered. This increases your customer liabilities and is added to the Net Credits total. |
| Work Order Deposit Credits | These are prior payments on orders delivered. These funds are no longer liabilities and are now recognized as payments for completed sales. For example customer gave you $50 last week to order a new custom tennis racket. The racket was picked up today and the customer paid the balance of $100. The sale is worth $150. The $50 prior payment is the Deposit Credit. This decreases your customer liabilities and is subtracted from the Net Credits total. |
| Work Order Deposit Refunds | These are deposits refunded to the customer because the order was canceled. This decreases your customer liabilities and is subtracted from the Net Credits total. |
| Net Credits | Net increase in customer liabilities a negative indicates a reduction in liabilities |