Month-End Reports

Recommended Month-End Reports

Stock Value Report

On the last day of the month print the Stock Value Report by selecting the following menu path: Reports > Inventory Reports > Stock Value

This provides a value for the inventory that is in stock (including stock that has been recorded by receiving purchase orders and New Receiving Reports). Once all supplier bills have been posted for inventory received during this period, the general ledger inventory account (normally account 1200) should be compared to the total stock value. These values should match. If they do not match a journal entry should be made to bring them in line.

Aged A/R Report

Print the Aged A/R Report by selecting the following menu path: Reports > A/R Reports > Aged A/R

The Aged A/R Report can actually be printed at any time (not necessarily at the end of the month since the book month can be selected). Periodically the total of this report should be compared the Accounts Receivable ledger account (normally #1050). If the values do not match, the A/R Integrity Check should be run to find out where the discrepancy is.

Customer Statements

Print the Customer Statements by selecting the following menu path: Accounts Receivable > A/R Reports > Statements

A preview of all account customers with balances is displayed allowing you to review and select only the ones you wish to send statements to.

Aged A/P Report

Print the Reports > A/P Reports > Aged A/P Report

The Aged A/P Report can actually be printed at any time (not necessarily at the end of the month since the book month can be selected). Periodically the total of this report should be compared the Accounts Payable ledger account (normally account # 2050). If the values do not match, the A/P Integrity Check should be run to find out where the discrepancy is.

Financial Reports

Print the financial reports. The standard ledger reports such as the Trial Balance, Balance Sheet and Income and Expense can also be produced at any time, not only at the end of the month, by selecting the Book Month.

The menu below shows the complete selection:

QuickReferenceGuide00000106.gif
 

List Unposted Journal Entries

Print the List Unposted Journals report by selecting the following menu path: General Ledger > Journal Entries > List Unposted Journals

This report lists all unposted journal entries. Usually these are the journal entries that you have made in Add Journal Entry and clicked [Save] instead of [Post]. They can also be journal entries that you have "Unposted" using Edit Journal Entry. When the List Unposted Journals window click [List] to create the report.

List Journals for a Month

Print the List Journals for a Month report by select the following menu path: General Ledger > Journal Entries > List Journals for a Month

This report lists all the postings for a single book month.

QuickReferenceGuide00000107.gif