Software for the Business of Being Creative® Since 1986  


       Ask Clients & Profits Sales Anything:

I need: a price quote   a web demo







     
   What is Clients & Profits?FeaturesTourPricingDemoNewsTraining & Support

Client Account Aging Snapshot Reports

Client aging reports show unpaid invoices from Accounts Receivable. These reports show how much clients owe you. Both show essentially the same information -- accounts receivable -- but in more or less detail.

invoice aging
account
retainer

Select the day you wish to show balances through using this pull down menu. The day can be selected from up to 12 months prior to today.

Invoice aging can be shown for client, AE/Team, or division.

Select the client you wish to show on the invoice aging report. If you want to show invoice aging for all clients, leave the option selected to ALL.

The aging periods are set to 30, 60, and 90 days by default, but you can completely customize the periods however you wish for them to show on the invoice aging report.

You can sub-total the invoices on the report for one particular dGL account number, or for all accounts. If there is a single dGL account that you wish to have shown on the report, select this checkbox and enter the dGL account number in the field.

Options to apply finance charges first, show year-to-date billings on the report, or show client names on the report can be selected here. These are all entirely optional.

Select the day you wish to show balances through using this pull down menu. The day can be selected from up to 12 months prior to today.

Client account aging can be shown for client, AE/Team, or division.

Select the client you wish to show on the client account aging report. If you want to show account aging for all clients, leave the option selected to ALL.

The aging periods are set to 30, 60, and 90 days by default, but you can completely customize the periods however you wish for them to show on the client account aging report.

Options to apply finance charges first, show year-to-date billings on the report, or show client names on the report can be selected here. These are all entirely optional.

Select the day you wish to show balances through using this pull down menu. The day can be selected from up to 12 months prior to today.

Retainer aging can be shown for client, AE/Team, or division.

Select the client you wish to show on the retainer aging report. If you want to show account aging for all clients, leave the option selected to ALL.

The aging periods are set to 30, 60, and 90 days by default, but you can completely customize the periods however you wish for them to show on the retainer aging report.

Options to apply finance charges first, show year-to-date billings on the report, or show client names on the report can be selected here. These are all entirely optional. If you find these options greyed out, you may not have access privileges to show these options on this report. Contact your System Manager for proper privileges.



Printing a client aging report

The Client Aging reports show individual unpaid invoices by client. The Client Account Aging doesn’t show invoices; instead, it shows account totals only.

All reports are useful to management, but have different purposes. The Client Invoice Aging shows every unpaid invoice, along with the aged balances. It’s most often used to track down late-paying clients and their invoices. The invoice aging can be a long report if you have a large number of unpaid invoices. The Client Account Aging is a short report, since it shows only one line per client -- but may not show enough information to help plan your cash requirements. Its most practical use is to quickly see who owes you money.

Client agings can be printed any time during the month, but especially at month-end. Client aging reports are always up-to-the-minute accurate, showing any posted invoice with a balance due. They can show what the client owes as of the moment the report is printed or through a prior period. For better accountability, unpaid invoices can be selected for one A/R account.

Client account balances can be aged into the current period and three user-defined periods (e.g., 30, 60, 90 days). These periods are flexible and can be changed any time the agings are printed. Any set of aging periods can be used. The aging option recalculates the unpaid balance based on today’s date and your aging periods. Your aged balances will only be accurate as of the last aging.

Client agings and the General Ledger

Client aging reports aren’t based on data from the General Ledger. Instead, client aging reports are based exclusively on unpaid invoices from Accounts Receivable. So what you’re seeing on client agings comes from your receivables, not from journal entries.

For this reason, they have the potential to be confusing. The client aging reports show a grand total at the bottom of each report. The balances on the client invoice aging will always match the client account aging -- they’re both based on unpaid receivables, after all. Since Accounts Receivable is integrated with your General Ledger, your receivables’ balances on the Balance Sheet should equal the balances on the aging reports. In some cases, they won’t match -- for an obvious reason: journal entries posted directly into the General Ledger for the A/R account do not affect client balances, and therefore the client account agings. For this reason, don’t make adjusting entries to the G/L for the A/R account; instead, make your adjustment directly into Accounts Receivable.

Client agings can be printed for some date in the past. The total balance due should always match the Balance Sheet printed for the same accounting period.

To print a client aging report

1 Choose Snapshots > Client Account Aging.

The Client Aging Reports window opens.

2 Choose the kind of aging report (i.e., Invoice Aging, Account Aging, or Retainer Aging)

3 Select to show balances through today or through a prior period.

4 Enter your aging periods.

These periods are used to calculate aged balances for every invoice, based on the invoice date and today’s date. You can use any set of aging periods, including a different set each time you print client agings.

5 Choose your aging options.

To see invoices for one specific A/R account, enter the receivable account number.

6 Click Print.



"Hands down, this Clients & Profits Helpdesk is the best of any support team." -- Kate Mistler, Fabiano Communications