How do I match Invoices and Payments?


The Transactions Report can be used to match and manage Invoices and their related Payments. The Click here to just show Payments for these Invoices button shown in the image below is a toggle button that switches between displaying the Invoices as searched for and their matching Payments or just displaying the Payments without all the Invoice details.
 
The details on how to run this report are given below.
How do I match Invoices and Payments?
1

Transaction Selection

1. Transaction Selection
Select whether Invoices or payments are to be found for the selected time period.
If Both, is chosen then the report options change, as shown below:
 
2

Date Range

2. Date Range
Select the relevant date range
3

Go

3. Go
Click Go
The results will display
4

Grouping

4. Grouping
If required, use the Grouping buttons to group your results.
Use Clear Grouping to remove the Grouping added
 
Additional grouping can be done using the Group By Box. This has been removed from the view above for simplicity.
To add the Group By Box in if it is missing
  • Right Click on a Column Heading
  • Click Show Group By Box.
5

Show related Payments/Invoices

These buttons toggle depending on the Transaction selection either, Invoice or Payments.
 
If Invoices, then the following button will display
5. Show related Payments/Invoices
Clicking this button removes the Invoices searched on from the display and just shows the relevant Payments
 
If Payments, then the following button will display
Clicking this button removes the Payments searched on from the display and just shows the relevant Invoices
6

Show/Hide Autofilter Row

6. Show/Hide Autofilter Row
 
Please tick the box to display the Filter Row
 
7

Invoice details

7. Invoice details
The results of the search are shown here. There will usually be multiple lines returned.
If, in this example, Invoices were searched for, then the relevant payments for that invoice are nested below it.
Click the + on the lefthand side of the Invoice line to expand and see the payments
 
Both Invoice ID and Payment ID fields are linked to the actual Invoice and Payment Records and these can be viewed in the Invoice Module.
 
Please note, if the Payment ID or Invoice ID state the word Multiple* this means that the record being viewed is linked to multiple with Payment or Invoice records.
 
8

Expand / Contract

8. Expand / Contract
The arrows can be used to Expand (down) and Contract (up) all of the lines returned in the results. Hence, all the nested lines will be seen.
9

Totals

9. Totals
These are the Invoice Total, GST Total and Payments Total.
These maybe in a different order if you searched for Payments rather than Invoices as I did in my example.
10

Excel

10. Excel
Export report to Excel
11

Preview

11. Preview
Preview report in Print Preview application    
12

Print

12. Print
Print report
13

Close

13. Close
Close report.