Verifying the Report Numbers
Bank Accounts
Run the G/L Transactions Report with the following filters:
Transaction Type: <<ALL>>
Posting Date thru: The date selected for the projection
Account: The selected bank account(s)
The debits plus the credits (a negative number) should equal the total amount on the Cash Projection for the bank
accounts.
A/R Aging
Run the A/R Aging Report with the following filters:
Market: The Market selected for the projection
Currency: Use the default currency or select a non-base currency
Outstanding as Of Date: The date selected for the projection
If <<ALL> is selected for “Include A/R Aged (as of date selected above) for” on the Cash Projections report, then the sum of the aged totals (not including the prepaid/overpaid column) should equal the total on the Cash Projection for the A/R Aging; and the individual columns on the aging should equal the individual columns on the projection.
If ‘Current’ is selected for the option, only the current column will be included on the projection. If “1-30 Days” is
selected, only the current column and the 1-30 Days column will be included. If “31-60 Days” is selected, only the
current column, the 1-30 Days column, and the 31-60 Days columns will be included; etc.
A/P Aging
Run the A/P Aging Report with the following filters:
Market: The Market selected for the projection
Currency: Use the default currency or select a non-base currency
Age as of: The date selected for the projection
Print Priority: Select ALL
The sum of the aged totals should equal the total on the Cash Projection for the A/P Aging; and the individual
columns on the aging should equal the individual columns on the projection.
Note that pre-paid amounts for A/R and A/P are not included in the projection in the A/R and A/P sections. Rather, it
is assumed they have already affected the balance in the bank accounts.