WELCOME TO GMS ACCOUNTING ONLINE HELP
The help you need at your fingertips.
You are here: Accounts Receivable > Accounts Receivable Analysis
Accounts Receivable Analysis
Function
The Accounts Receivable Analysis gives you a listing of all outstanding invoices as of the “from” and “to” date entered and a 30/60/90/plus day aged listing of your outstanding invoices. When checking for outstanding invoices on the analysis, it will use the deposit date of the cash receipt when comparing to the “to” date. The posting period of the A/R batch is used to compare to the “to” date. For the aging section, it uses the invoice date
and deposit date to compare to the “to” date.
Things You Should Know
Operating Instructions
Period: When you click on the AR Analysis menu item a form will be displayed with “from” and “to” dates. All month beginning and ending dates will show if any invoices have a posting period in that month or cash receipt document dated in that month. When reconciling to your General Ledger, choose the month ending date for the month to be reconciled.
Sort: Select if you want the analysis sorted by alpha code, invoice number, date, name or by customer code or by customer code excluding invoice detail.
Note: For agencies who wish to see the outstanding invoices by program element, you can double click on the query called rptOSInvoiceAmount.
Instructions for using rptOSInvoiceAmount
For Access database:
For SQL Server Database:
Aged Analysis Info: This will print your aged listing.
Analysis Info with Description: Selecting this option will show each invoices description but will not “age” the invoices.
The Accounts Receivable Analysis gives you a listing of all outstanding invoices as of the “from” and “to” date entered and a 30/60/90/plus day aged listing of your outstanding invoices. When checking for outstanding invoices on the analysis, it will use the deposit date of the cash receipt when comparing to the “to” date. The posting period of the A/R batch is used to compare to the “to” date. For the aging section, it uses the invoice date
and deposit date to compare to the “to” date.
Things You Should Know
- When an invoice is paid in full, it will no longer appear on this listing according to the dates listed.
Operating Instructions
Period: When you click on the AR Analysis menu item a form will be displayed with “from” and “to” dates. All month beginning and ending dates will show if any invoices have a posting period in that month or cash receipt document dated in that month. When reconciling to your General Ledger, choose the month ending date for the month to be reconciled.
Sort: Select if you want the analysis sorted by alpha code, invoice number, date, name or by customer code or by customer code excluding invoice detail.
Note: For agencies who wish to see the outstanding invoices by program element, you can double click on the query called rptOSInvoiceAmount.
Instructions for using rptOSInvoiceAmount
For Access database:
- In Microsoft Access, open your database.
- Click on Queries under Objects on the left.
- Locate rptOSInvoiceAmount and double click to open it.
- You may print from Access or you may export to Excel.
For SQL Server Database:
- On the server, go into Microsoft SQL Server and open Enterprise Manager/SQL Management Studio.
- Click on SQL Server Group and double click on Databases. Locate Conversion SQL and double click on it.
- Click on Views. Find rptOSInvoiceAmount from the lists. Right click on it and chose Open View (return all rows if using SQL 2000).
- Copy and paste into excel.
Aged Analysis Info: This will print your aged listing.
Analysis Info with Description: Selecting this option will show each invoices description but will not “age” the invoices.