Month End Reports

The Month End reports can be set up in the Report Form Printer set up to go on hold before printing or be saved after printing.  We strongly suggest that all Month End reports be saved after printing for recovery purposes if needed.

 

Standard Reports Generated During Month End.

ARDEFRP: Sales Report by Charge code within Cycle

Purpose: Detail listing of current sales for analysis and auditing.

 

ARDEF2P: Sales Report by General Ledger Code

Purpose: Summary listing of all sales by General Ledger code, used for auditing and report. Can be used for journal entries. Used in Month End Balancing.

 

ARW545P: Monthly Invoice Summary by Cycle

Purpose: Summary report of sales that are not auto or finance charge for management. Can be used as comparison to prior month to see ‘how we are doing’.

 

ARW545P: Monthly Auto Charge Summary by Cycle

Purpose: Summary report of all auto (recurring) charges in the month used as a billing comparison to last month – ‘how are we doing’.

 

ARW545P: Monthly Finance Charge Summary by Cycle

Purpose: Summary listing of Finance Charges by date within cycle. Used in to verify finance charges.

 

LSTCSHP: Cash Receipts Summary by Cycle

Purpose: Summary listing of payments posted during the month by Date within Cycle. Used in Month End Balancing.

 

LSTGLFP: Automatic Journal Entries by General Ledger Code

Purpose: Provides a listing of all journal entry postings (Cash & Sales).

 

STCASHP: Cash Basis Sales Tax Report by Tax Body/Class within Cycle

Purpose: Provides a listing of payments received against sales and tax used for reporting tax based on a Cash Basis.

To ensure correct easy-to-read reporting, make sure for each tax body and tax class there is a ‘married’ record even if the taxation amounts are 0.

 

STACRUP: Accrual Sales Tax Report by Tax Body/Class within Cycle

Purpose: Provides a listing of sales and tax by Tax Body and Tax Class, used for reporting tax based on an accrual basis

To ensure correct easy-to-read reporting, make sure for each tax body and tax class there is a ‘married’ record even if the taxation amounts are 0.

 

ATB2: Aged Trial Balance Summary by Cycle

Purpose: To provide a summary aging by cycle. Used for Month End balancing.

 

ATB: Aged Trial Balance Detail by Customer within Cycle.

Purpose: To provide a detail aging by customer for collections. May also be used to review unbilled amounts (to check if a cycle was not included in Open Statement Invoices).