Accounting Reports

The Accounting tab contains system reports that provide General Ledger, Journal Export, Z-Out, and financial accounting information.

Reports	Description
Financials	A collection of standard reports using data drawn from the Accounting Summary table, which reflects shipped orders (orders that are assigned a ship date), for the purpose of accounting.
General Ledger	Legacy tool, not currently recommended.
Journal Entry Export Manager	Used to manage export files from CORESense into Transaction Pro for QuickBooks imports.
Z-Out	View of daily POS transactions that can be filtered by store, POS or Company. The Z-Out Report can run at the POS, Store or Sales Channel level to display the status of POS systems on a specified date. Note : Can be exported (CSV), when run for the "Channels" option.

Cash Accounting

For cash accounting the fundamental rules for reporting that change the accounting tables are:

Any addition or removal of payment
When an order is either partially or fully shipped

Those are the only actions that initiate changes in the Financials reports. Once either a payment or shipping has occurred against an order, it qualifies for posting to the accounting table and is recognized when the cron runs every four hours. The cron runs at 5 minutes past the hour, every 4 hours, starting at midnight: 12:05, 4:05, 8:05, 12:05, 4:05, and so on.

If a situation is encountered that requires order recalculation, a process is initiated to determine the delta between the old and new states.
Based on this delta, new accounting_summary and accounting_summary_item rows are created with appropriate positive or negative amounts.
No existing accounting_summary or accounting_summary_item rows are deleted or changed.

NOTE: Custom times can be set per customer, i.e., you can request a specific cron run times, such as 5:42 PM if there was a use case.

COGS does not display on orders until inventory is assigned due to the fact that it is not yet determined from where the order is being sourced per each piece of inventory.

Accounting Entry Data

The table below lists common accounting entry data and the related CORESense report that contains that information.

Important: To obtain reports for accounting purposes, use the Financials option in the Report manager drop-down list.

Accounting Entry	CORESense Report
Revenues	Accounting > Financials > Sales Report
Gross Profit	Accounting > Financials > Sales Report
Returns	Accounting > Financials > Sales Report
COGS	Accounting > Financials > Sales Report
Cost of Shipping	Accounting > Financials > Sales Report
Sales Tax	Accounting > Financials > Sales Report
Received Payments (by payment type)	Accounting > Financials>Payments Report
Value of Inventory	Report Center > Inventory Costs
Accounts Receivable*	Report Center > Accounts Receivable Report

*Note: The current Accounts Receivable report is really an “Unpaid Orders” report. It does not include any customer credits that are available but have not been specifically applied to an order.