Reporting Against Client Funds

There are multiple ways to report against customers within QuickBooks, but using the default reports provided, you are unlikely to find exactly what you are looking for. In this section, we are going to build a custom report from scratch, starting with the trial balance:

Figure 5.26 – Trial Balance

In this example, we are left with £3,000 that relates to a deposit received against a property. We are interested in looking at the movements against a particular tenant account, so the next step is to click on the value against Client Ledger Balances:

Figure 5.27 – Detailed transactions against Client Ledger Balances

At this point, we have a report showing entries against every single client, property, and tenant, but we are only interested in one. Our next step is to use the Customise option found in the top right of the screen:

Figure 5.28 – Using the Customise...