Reports

Compeat provides a variety of reports to help you view your key data quickly and easily for management, research, and audit trail purposes (not all reports are listed or shown).

Financial Reporting

eXcellent™ Financial Functions may be the most exciting feature in Compeat. eXcellent™ redefines ease of use, with endless flexibility that simply is not available from other financial reporting systems.

The eXcellent™ Financial Functions were developed by Compeat. They are extremely powerful add-in worksheet functions for Microsoft Excel that provide the ability to effortlessly extract financial data from Compeat's general ledger and budget tables.

People who have experience with report writers like FRx and Crystal Reports know how difficult it can be to create reports from scratch and even modify existing reports. And those report generators can be limited in the information they can calculate and present on a report.

Conversely, while almost everyone knows how to use Excel (for example, most people are familiar with Excel worksheet functions like SUM()), most find that it is too difficult, if not impossible, to get the data from the general ledger into Excel so that it could be used to create financial reports.

+ Click the image above for a larger view +

Therefore, if you could solve the issue of getting the general ledger data into Excel using the familiar worksheet function format, you would have the best of both worlds -- easy access to your financial information using a powerful yet familiar spreadsheet tool. This is exactly what the eXcellent™ Financial Functions do: they capture the numbers you need from the general ledger and put the results in a spreadsheet, which you can then manipulate, format, and graph anyway you want.

Learn about Inventory >>

Below is a list of other reports you can run with Compeat Back Office. Note that not all reports are shown or listed.

Registers

DSR, AP Transaction, Manual Check, General Journal, Inventory, Payroll. Lists of posted transactions. You can produce registers at the time work is posted, and you can print duplicate registers from the reports menu at any time.

Invoice History Report

Prints a list of all invoice records that meet your criteria. You can select invoices by restaurant, vendor, invoice date, apply date, inventory number, and account number.

Manual Check History

Report Prints a list of all manual check records that meet your criteria. You can select manual checks by restaurant, vendor, voucher date, apply date, inventory number, and account number.

Vendor Aging

Report Prints an aging report grouped by vendor for all invoices and credit memos that meet specified criteria. You can select the report to print by restaurant, vendor, cutoff date, aging date. You can age the report by the voucher date, the discount date, or the due date.

Check Register

Prints a history of the activity that has occurred for a specified bank account for a specified date range. You can select which types of transactions appear on the report.

General Ledger

Report Prints posted financial information. You can select which restaurants, GL account ranges, and date ranges to include on the report. You can subtotal by restaurant, by period, or by day. Alternatively you can specify journal control numbers or a batch code to see just those entries.

DSR Comps

Report Prints the comps posted from the DSR. You can select the comps by restaurant and date. You can group the report by manager or by server.

Invoice History

Besides common selection criteria such as date ranges and vendor, Compeat also provides other unique selection criteria. Select all invoices that were coded to a particular GL account number and/or all invoices that contained a particular inventory item. Results may be displayed in summary (shown below) or detail.
Check Register

Compeat's check register is unique in that it shows the source of all changes to the the bank balance including journal entries. Compeat also indicates the source of deposits coming from the DSR by indicating Visa, American Express, Cash, etc. This feature also shows up in Compeat's check reconciliation functionality. Status codes include Open, Cleared, Marked (marked cleared but not yet reconciled), and Voided.

Learn about Inventory >>