How to complete a Accounts Payable Ledger

The Accounts Payable Ledger tracks all money your business owes to vendors and suppliers, showing invoice details, payment history, and remaining balances. Lenders require this to verify your current liabilities and assess whether your cash flow can handle existing debt obligations.

- Gather all unpaid vendor invoices with invoice numbers, dates, and amounts owed - Collect proof of payments made during the reporting period, including check numbers, wire confirmations, or electronic transfer records - Have your general ledger or accounting software reports showing vendor account activity - Compile vendor contact information including full business names, addresses, and payment terms for each creditor - Select your governing state, as some states have specific requirements for how payables must be reported and aged

1. Enter your business legal name, reporting period end date, and governing state at the top of the form. The state selection may affect aging categories and disclosure requirements. 2. Create a header row with columns for Vendor Name, Invoice Number, Invoice Date, Invoice Amount, Due Date, Amount Paid, Payment Date, and Outstanding Balance. 3. List each vendor alphabetically or by total amount owed. Include the complete legal business name exactly as it appears on invoices to avoid confusion. 4. For each vendor, enter every unpaid or partially paid invoice as a separate line item with its unique invoice number and original invoice date. 5. Record the total invoice amount in the Invoice Amount column, then enter any payments made in the Amount Paid column with the corresponding Payment Date. 6. Allow the form to auto-calculate the Outstanding Balance by subtracting Amount Paid from Invoice Amount. Verify each calculated balance matches your internal records. 7. Note the Due Date for each invoice and flag any past-due amounts. Many forms color-code or separate items by aging buckets such as current, 30 days, 60 days, and 90-plus days past due. 8. Total each column at the bottom. The Outstanding Balance total represents your current accounts payable liability and should match your balance sheet. 9. Sign and date the completed ledger, certifying that all vendor obligations are accurately reported as of the period end date.

- Banks scrutinize past-due balances exceeding 60 days because chronic late payments signal cash-flow problems and may indicate your business cannot service additional debt. - Ensure your total outstanding balance on this ledger matches the accounts payable figure on your balance sheet. Discrepancies raise red flags and delay loan approval. - Avoid lumping multiple invoices into single line items. Lenders want transaction-level detail to verify that obligations are legitimate business expenses, not disguised owner withdrawals or related-party transactions.