The Accounting Summary report displays the total sales for the period for a store along with the amounts received through each payment mode, and indicates whether the accounts for each day are reconciled.
The data in this report includes data received from your POS system Point Of Sale system - the system/register used to bill customers and track sales. as well as data entered manually via the Daily Entry pages.
-
The Accounting Summary report can be subscribed to by clicking on
. Click here to learn how to create a subscription. -
Click on the Show Store(s) Not Reporting button to view the stores that don't have any sales recorded for the period.
The following information is displayed in the report based on the constraints selected when producing it:
-
Adjusted Gross Sales: Sales obtained after subtracting the Tax^ and a few other items* (depending on how your POS is set up) from the gross sales.
The Cash Sheet > Summary page provides the fields subtracted from the gross sales to arrive at the adjusted gross sales for your organization.
Adjusted Gross Sales = Gross Sales - Non-Food Sales - Tax^
-
Net Sales: Sales obtained after subtracting deductions from the adjusted gross sales.
The Cash Sheet > Summary page provides the fields subtracted from the adjusted gross sales to obtain the net sales for your organization.
Net Sales = Adjusted Gross Sales - Deductions
OR
Net Sales = Gross Sales - Non-Food Sales - Tax^ - Deductions
-
Tax^: Tax collected on the sales.
-
Counted Cash: The total domestic currency cash accounted for in the period (entered as Cash on the Banking Information page).
-
Foreign Cash Equiv.*:The domestic currency equivalent of the total foreign currency accounted for in the period (entered as Foreign Cash on the Banking Information page).
The Foreign Cash Equiv. column is displayed only if the Foreign Cash Handling control is set to Yes.
Click here to learn how to enable/disable Foreign Cash Handling A setting for organizations that accept foreign currency..
-
Total Cash*: The domestic currency equivalent of all cash deposits for the period.
Total Cash = Counted Cash + Foreign Cash Equiv.
-
Charge Type (where Charge Type is a mode of payment accepted by your organization): Total value of the transactions for the day for that particular mode of payment.
Click here to learn how to create, edit and delete Tenders.
-
Rebates: Total value of non-menu item sales for the period.
The complete list of rebates for the period can be found on the Rebates page.
-
Bottle Deposits: Total value of bottle deposits collected.
-
Deposit: Total value of actual amounts received from all payment methods.
Deposit = Counted Cash + Foreign Cash Equiv. + Charge Type 1 + Charge Type 2 + Charge Type 3...
-
Over/Short: The difference between the actual amount received and the expected amount received (based on recorded sales, rebates, bottle deposits, etc.).
Over/Short = Deposit + Total Payouts - (Net Sales + Tax^ + Rebates + Bottle Deposits)
A positive figure indicates that the actual amount received is more than the expected, whereas a negative figure indicates that the actual amount received is less than the expected.
The following information is displayed in the Payout Information* table:
The Payout Information table is displayed only if there were payouts Cash removed from a register for payments (paying a window cleaner, tipping a delivery person, etc.). recorded for the period selected when producing the report.
-
Category: The category in which the payment is grouped.
Click here to learn how to create, edit and delete Payout Cash removed from a register for payments (paying a window cleaner, tipping a delivery person, etc.). Categories.
-
Date: The date for which the payout Cash removed from a register for payments (paying a window cleaner, tipping a delivery person, etc.). was recorded.
-
Amount Paid: The amount paid out.
-
Tax^: Tax on the payout Cash removed from a register for payments (paying a window cleaner, tipping a delivery person, etc.)..
-
Total Paid: The total amount paid.
Total Paid = Amount Paid + Tax^
The Accounting Summary report for your organization may contain additional columns customized for your organization.
TO VIEW AN ACCOUNTING SUMMARY REPORT:
-
Open the Accounting Summary page.
-
Select the Area* and Store for which you want to view the report from the drop-down list(s).
-
Select the Period for which you want to view the report from the drop-down list.
-
Select the specifics of the period (Date*, Year*, Week Ending*, Month*, From*, To*) from the drop-down list(s).
-
Click on the Go button.
Associated Settings
-
Financial Reporting controls the period considered a financial week for the organization.
-
Cash Handling controls the cash settings for your organization.
-
Tenders controls the modes of payments accepted by your organization.
-
Payout Categories controls the categories that can be selected for payouts Cash removed from a register for payments (paying a window cleaner, tipping a delivery person, etc.)..
^or HST or GST and/or PST or VAT/VAT Exempt (as per your location)
*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.