Excel Accounts Receivable and Aging Worksheet

by Dave

Excel Accounts Receivable and Aging Worksheet

Excel Accounts Receivable and Aging Worksheet

Do you happen to have or know where an accounts receivable aging worksheet created in Excel can be found and downloaded? I am wanting to find one that has the formulas in place, so to see just how it should be setup.

There are several examples out there, but all so far I have located do not include the formulas; just the column headings <30 days; >30days; >60 days and so on. Most of the examples look great, but seem to be missing that key component "the formulas." I realize this is a basic Excel 101 type of request, but a person needs to start somewhere.

I would greatly appreciate any information or assistance where to find such an example.

Thanks every so much.


Comments for Excel Accounts Receivable and Aging Worksheet

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 07, 2017
Accounts Receivable Excel Template
by: Stephanie

Hi Dave,

Thank you for your questions regarding Excel Accounts Receivable and Aging Worksheets. You might want to try the billing statement template download at https://www.vertex42.com/ExcelTemplates/billing-statement.html. It can be used for straight accounts receivable invoice tracking, customer management and general billing.

It has a column for recording the invoice number, a column for recording payments received and an other charges column. Unlike an invoice template, the billing statement template can be used as an accounts receivable ledger. The website also offers many other useful Excel business templates.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Please subscribe to my monthly newsletter, Bookkeeping Basics E-zine. It tells you every month about the new information that I have added, including some great tips and advice from myself and other Bookkeeping Basics readers.

Enter Your E-mail Address
Enter Your First Name (optional)

Don't worry — your e-mail address is totally secure.
I promise to use it only to send you Bookkeeping Basics E-Zine.

Like Bookkeeping-Basics.net?