How can I add a fifth column to the aging default categories? The bank requires us to list a/r that is over 120 days. Will we have to manually go through the accounts each month? Please help!!!
Go to the top of the Accounts Receivable aging form. Go to Options > Columns > check Age and due date. Make the columns skinny or remove all of the other columns that you don't need. Now save with your new report with a custom name and description. It will be at the top of the column with a wrench beside the name. This indicates that it is a custom report.
For more tips and tricks follow us on Facebook. www.facebook.com/.../
What document are you referring to? I need the "Aged Receivables" report to have five aging categories. There must be a way to get Sage to calculate this. The customer default aging tab only has the option for four columns.
Please follow my instructions above. This can be taken to excel to be modified if needed.
Or modify periods in Options tab > Customer Defaults:
I don't believe you can add a 5th column. Shirley's example properly shows only the option for 4 in the Sage program.
Option is to run the report with four. Then change the Options tab > Customer Defaults for new Options
Make column three 61-120 & Change the last column to >120 days | Save the Customer Default setup
Rerun/print the report which will provide the >120 days
You can then back-out that number from the 61-120 day totals. Export to Excel and manipulate from there to submit to bank.
Admittedly it is a work-around.
You are correct JP. You can put any aging numbers you want in any of the columns. And by removing columns in the AR report, you won't even have to take it to Excel to modify.
HERE ARE SOME SAMPLES:
Save it so you never have to recreate the report again:
This is a great book if you need more reports:
Great idea! Thanks so much!!!
*Community Hub is the new name for Sage City