Xero Bookkeeping: Accounts Receivable and Accounts Payable

Reading Time: 2 minutes

When checking to make sure you’re using Xero accurately, one of the make sure you check up on your Accounts Receivable (AR) and Accounts Payable (AP). These accounts reveal whether invoices and bills are being managed properly, and errors here can create mismatches that affect both cash flow and financial reporting.

Two Types of Xero Users

Not all businesses use Xero in the same way:

• Invoice Generators – Invoice generators make and send their invoices through Xero, collect payments, and record deposits through the system. It’s all contained within the Xero software
• Transaction Importers – Transaction importers usually import their transaction data from a bank feed, integration with another app, or by importing transactions. The Xero and Square integration is a common one we see, and part of what makes Xero a top choice for us.

If a transaction importer, you might want to set up more check points, because your Xero data may not reflect reality — invoices might remain “open” even though the bank shows deposits, or vendor bills may show unpaid even after being settled. You’re managing transactions through two systems, which means it’s good to check both, even when the likelihood of error is pretty low, like it is with Xero

Common Issues in Accounts Receivable and Accounts Payable Cleanup

• Invoices showing as Unpaid even though payment was received in the bank.
• Vendor bills are Unpaid even after payment was made.
• Duplicate transactions and invoicess when both an invoice and a bank feed record the same payment.
• Accrual-basis reporting mismatches, where bills and invoices appear but don’t match actual cash flow.

How to Review in Xero

1. Run the Balance Sheet report – Scroll down to Accounts Receivable and Accounts Payable.
2. Check open invoices and bills – Compare them against bank deposits and payments.
3. Close out old or incorrect entries – Mark invoices as paid and clear vendor bills that were already settled.

The 5-Step Xero Cleanup Framework

At Akif CPA, our bookkeeping cleanup process reviews five key areas:

1. Financial Reports – Profit & Loss and Balance Sheet.
2. Chart of Accounts – Ensure categories are accurate.
3. Bank Reconciliation – Match Xero with bank statements.
4. Bank Rules – Fix misclassifications caused by automation.
5. Accounts Receivable & Accounts Payable – Ensure invoices and bills match actual cash flow.

When all five areas are reviewed and corrected, your bookkeeping will be accurate, reliable, and tax-ready.

In this Xero video series, we’ll walk through a demo company in Xero and show you exactly what to look for to make sure you’re using the software correctly: https://youtu.be/FwIviMY5W7s