Revenue Report Setup

Action: REVRSETP

The revenue report is automatically configured with the installation of ProfitSystem. It may be customized under BBL tech support direction.

The ProfitSystem Revenue Report is a detailed accounting report designed to recap the day's business. It is suitable for accountants to make postings into a general ledger.

ProfitSystem is installed with pre-set standard ProfitSystem account names/numbers and the Revenue Report is set to use these default accounts. In most business situations the detail of the report is adequate. Accounting Classes are also preset. Accounting classes are assigned to inventory. When an inventory item is sold, postings are made to the ProfitSystem account numbers assigned to the accounting class.

Tender types are assigned ProfitSystem account names/numbers in Accounting setup form, so when payments are made the proper postings are created.

The Revenue Report simply scans thru the postings file for the date range requested by the user and totals the amount for each ProfitSystem account name/number and prints that total on the Revenue Report in the section it is instructed to within this form. Due to overall system ramifications BBL recommends that a store does not modify any existing accounts, but only add to the Chart of Accounts and Accounting Classes on file. For extensive modifications the customer should consult with BBL for customization services.

The Revenue section of the report is divided into eight groups.

1 - Header, One Receipt Group. Non Customizable
2 thru 5 - Middle, Five Customizable Groupings
7- Tax, One group for tax total, Non Customizable
8 - Footer, One Section, Non Customizable

For each middle customizable grouping specify which ProfitSystem account names/numbers should be totaled for that grouping. Each grouping is then sub-totaled on the report, and the total of all the groups is printed at Grand Total Revenue report line.

In groups 2 - 5 do not duplicate Account numbers in the report. Insure Account numbers are NOT duplicated in setup, example the same Account number used for CASH tender payments and Check tender payments. This will double count the money collected.

Group 1: Header - Receipts (non customizable)

Receipts by tender type
Remote payments (multi-store feature)
Security Deposits as payments
Receipts total

Group 2 - 5: General Report Sections (Revenue & Non Revenue - customization)

Section 1
sub-total
Section 2
sub-total
Section 3
Sub-total
Section 4
sub-total
Section 5 (good section for non-revenue accounts)
sub-total Sections 1-5 total (sub-total) Auto configured section entries

Inventory (default in section 2)

Cost (default in section 2) Inventory & Cost postings should balance to 0 (zero) See accounting class topic for more info. Un-Applied payments (default in section 5) Money collected but not applied to any sale item, usually creates a store Credit with the customer, Positive money going into a store credit, a negative is where a store credit is being used as a payment on a ticket. Deposit/Receivables (default in section 5), Deposit or Receivables. Based upon Accounting method chosen in Accounting Setup.

Group 6: Sales Tax Group (non-customizable)

Fixed, cannot be modified. List all tax rates and their total for period. Tax Total

Group 7: Grand Total of Groups 2 - 6 (non-customizable).

This Grand total number should equal the total Receipts total number.

Footer will automatically insert helpful information.

It will print Taxable/ Non-Taxable Sales with tax collected for each by category

When printed in DETAIL MODE, i.e. show ticket details, Deleted ticket line item alert message will print indicating a clerk has deleted ticket transactions.

With WinTPS optional software installed- Canceled Late Fees will print. A system setting exists to disable this feature.

Paid In & Paid Outs are listed.

Group Customization

Report Section to view box Report section to view, Section 1 thru 5...You can specify up to 40 ProfitSystem account names/numbers to include in each section. Select the section you wish to work with here.

Grid

ProfitSystem account names/numbers to include in selected Section...Enter the Account names/numbers to be listed and totalled within this selected section.

To add a Account, find the first blank entry, click in the ProfitSystem account names/numbers column, and enter the Account name/number. You can also press F2 to bring up the pick list of ProfitSystem account names/numbers.

To remove a Account, simply clear it from the list.

Show +/- checkbox: instructs ProfitSystem® to show both inflows and outflows to this account on the Revenue Report, or just print the net total. Checked ProfitSystem® will show inflows and outflows as separate negative and positive totals for this Account on the Revenue Report.

General

Show account numbers on revenue report?...Normally unchecked. If checked, ProfitSystem® will print the actual GL account numbers on the revenue report, in addition to the descriptive names from the Chart of Accounts form.

Show accounts with zero totals?...If unchecked, ProfitSystem® will suppress lines on the Revenue Report with zero totals. For example, if you had no AMEX receipts for a day, the AMEX line would not appear on the revenue report. If you check this, the revenue report will include every line.

Show +/- on receipts?...If checked, ProfitSystem® will show both inflows and outflows to each receipt account on the Revenue Report. If un-checked, ProfitSystem® will only show the net total.