Accounts Receivable Ledger
Remaining Columns Explained
The total of 10,620 heads up the F Column and is the total of all invoices that are due for payment. This column has formulas in it so it is very important that you do not type anything into the cells in this column because you will end up removing the formulas.
The Current Date is automatically set by Excel using the date setting on your computer.
Accounts Receivable Ledger Payments Columns
F Column - The balance due amounts are automatically calculated by taking the sum of the payment amounts away from the total invoice amount found in Column D.
G to R Columns - Every time your customer makes a payment you will enter the payment amount into the next available column - so if H and I already had payments entered in you would enter the payment into column J.
Column G - Red Triangle - If you are familiar with Excel you will know that the red triangle indicates a comment. You can insert, edit or delete comments by clicking your right mouse button. This is great for entering the date a payment was received so you can easily track how fast the customer is paying off their invoice.