Home → MediaPlus Advertising Accounting → End of Month Procedures → Accounts Receivable Reports (EOM)

5.8. Accounts Receivable Reports (EOM)

G/L Transaction List

1.    From the Software menu, select Accounts Receivable | Reports | G/L Transaction List.

2.    Ensure that the All boxes under the Client, Invoice, Creation Date, and Transaction Code headings are checked.

3.    Uncheck the All box under the Transaction Date heading, and click on the Calendar icon adjacent to the blank field.  A window entitled Transaction Date will appear.

4.    Under the Enter Selection heading, enter the range of dates for the reporting period (i.e. first and last dates of the month), or click on the Calendar icons to select these dates.  Then click on the OK button.

5.    Uncheck the All box under the G/L Account heading, and click on the Search icon adjacent to the blank field.  A window entitled G/L Account will appear.

6.    Under the Enter Selection heading, you may click on the Search icon and add all the G/L accounts that apply to your location.  However, as the number of accounts may be rather large, you may prefer to simply enter a range of accounts or exclude certain ones.  To enter a range, click on the Search icon adjacent to the left-hand field, and select the lowest numbered account.  Then, click on the Search icon adjacent to the right-hand field, and select the highest numbered account.  This information will appear under the Includes all heading.  To exclude an account, click on <NEW> under the Excludes heading, and search for the appropriate accounts.  These will appear under the Excludes heading.

7.    Ensure that both the Print Selection Criteria and Preview boxes are checked under the Miscellaneous heading.

8.    Click on the Sort tab.  Under the Sorting heading, arrange the list by dragging and dropping the criteria in this order: (1) G/L Account, (2) Client, (3) Transaction Code, (4) Invoice, (5) Profit Center, (6) Creation Date, (7) Transaction Date.
 
9.    Under the Breaking heading, check the G/L Account box.

10.    Under the Clients sorted by heading, select the Name option.

11.    Click on the Start Process icon, or strike the < Alt + F2> keys.  Print the generated report.


Cash Ledger

1.    From the Software menu, select Accounts Receivable | Reports | Accounting Ledger.

2.    Click on the Search icon adjacent to the Identification field and select CASH.  The fields should now read CASH and CASH LEDGER.  The Format fields should read CASH and CASH FORMAT, and the Type field should read “Cash Receipt”.

3.    Click on the Calendar icon adjacent to the field under the Transaction Date heading.  A window entitled Transaction Date will appear.

4.    Under the Enter Selection heading, enter the range of dates for the reporting period (i.e. first and last dates of the month), or click on the Calendar icons to select these dates.  Then click on the OK button.

5.    Under the A/R Account heading, uncheck the All box and click on the Search icon adjacent to the field.  Select the G/L Account specific to your location, and then click on the OK button.

6.    Under the Profit Center heading, uncheck the All box and click on the Search icon adjacent to the field.  Select the profit center specific to your location, and then click on the OK button.

7.    Ensure that all the remaining All boxes are checked.

8.    Under the Post Status heading, ensure that the All option is selected.

9.    Under the Miscellaneous heading, ensure that both the Print Selection Criteria and Preview boxes are checked.

10.    Click on the Sort tab.  Under the Sorting heading, ensure that Client is at the top of the list.  Otherwise, drag and drop it to this location.

11.    Under the Clients sorted by heading, ensure that the Name option is selected.

12.    Click on the Start Process icon, or strike the < Alt + F2> keys.  Print the generated report.


Sales Ledger

1.    Follow the same procedure as for the Cash Ledger, except for the Identification field selection.

2.    Click on the Search icon adjacent to the Identification field and select SALES.  The fields should now read SALES and SALES LEDGER.  The Format fields should read SALES and SALES FORMAT, and the Type field should read “Sales”.

3.    Click on the Start Process icon, or strike the < Alt + F2> keys.  Print the generated report.