Academy

List all payments with the Payment Register

See every customer receipt and vendor payment in a period, with its method, status and how much is allocated to invoices.

Accounting Reports 7 steps 2:06 video Accounting - Manager
Where to find it AccountingReportsPayment Register

Steps

  1. Open Accounting > Reports and choose Payment Register under Management.
  2. Type the From and To dates and press Tab after each, or pick a ready-made Period.
  3. Each line is one payment. You see the Date, the Type (customer or vendor), the Payment number, the Partner, the Journal, the Method, the Status, the Reference, the Currency, the Amount, how much is Allocated to invoices or bills, and how much is still Unallocated. A payment you register straight from an invoice or bill counts as allocated.
  4. Open Payment Type and choose Vendor Payments to see only the money you paid out, or Customer Payments to see only the money you received. Bank / Cash, Payment Method and Partner narrow the list further.
  5. Open Allocation and choose Not Fully Allocated to list only the payments that are not matched to an invoice or bill yet. Choose Fully Allocated for the others.
  6. Click a payment number to open the payment, then click Payment Register in the path at the top to return to the register. Type in Search to find one payment.
  7. Click Export and choose PDF, Excel or CSV.

Note

A payment with an amount in Unallocated has not been matched to an invoice or bill yet, so it still sits on the customer's or vendor's account. See Unallocate a payment and Record an advance payment.

Tip

Cheques you have received or issued with a future date are in their own report: Post-dated Cheques.

What happens next

To see the effect of the payments on what customers owe, run Aged Receivable.

Was this lesson helpful?

Keep learning

Run a Profit and Loss report See your income, cost of goods sold, expenses and net profit for any period, compare it with last year or month by month, and open the entries behind any figure. Accounting Reports7 steps2:01 video Run a Balance Sheet See what the company owns, what it owes and what is left for the owners on any date, and compare it with last month or month by month. Accounting Reports6 steps1:57 video Run the Cash Flow report See where your cash came from and where it went in a period, split into operating, investing and financing activity. Accounting Reports6 steps1:33 video