AR aging [in-depth guide]
Shows all accounts receivable with open balances and aging.
Search criteria:
Age receivables as of
This date field is key when using this report. It looks at the posting date set on the client invoice or receipt. It will act as if no transactions exist after this date. So if you are running the report as of a past date, keep in mind you may see transactions that have already been accounted for after that date.
Using
This allows you to select how you wish to view the different aging buckets. Though the age receivable date selected above is always going to show you transactions as of the posting date, this allows you to view your aging buckets using one of the following date fields; invoice date, due date, or posting date.
Client
Limits the results to a specific client.
Parent client
Limits the results of specific parent clients and/or all of its child companies.
Company
Appears that you have GL companies enabled. Limits results to open transactions for that GL company
AR account
Limits results based on transactions for that AR account.
Currency
Appears only if you have multicurrency enabled. Limits results based on transactions for that currency.
Find date of last balance
This can be used for the system to try and locate the last date your AR tied out. Please contact support@workamajig.com if you have questions about this feature.
Posted transactions only
Limits the results to only show transactions that have been posted to the GL.
Report source
Client invoice - Reflects the "Open" unpaid amounts of all (regular and advance bill) client invoices.
Advance billings - Reflects the "Unapplied" amount of all advance bill client invoices.
Unapplied receipts - Reflects the "Unapplied" amount of all receipts.
Display options
Include sales taxes on advance billings
If checked, Sales taxes will be included on advance billings.
AE view
Groups the results by the account manager of the project linked in the header of the invoice. If no project is listed in the header for the invoice, then it's grouped under no account manager.
AE view page break
Same as above yet does a page break before each AEs name when you export to PDF only.
Summary view
If checked, the report will be made into one line per client.
Project column displays
Choices include; project number and Name (default), client product, or client division.
Hide multiple projects
If a single invoice has multiple lines for more than one project, then this will hide the list of projects and replace it with "Multiple Projects".
Group by office
Groups the results by office if set on the invoice and project.
Only invoices older than
User adjustable to only return data that is older than X days from the as of date at the top of the search options.
First period
User adjustable, typical use is 30 days.
Second period
User adjustable, typical use is 60 days.
Third period
User adjustable, typical use is 90 days.