Comparing Xero Balances with LEAP Reports

16/10/2023
Knowledge

How To

Before you start it is valuable to periodically compare the balances in LEAP and Xero in order to confirm that the general account balances are in complete agreement. In particular, it is crucial to do so when initially beginning to use the two systems, as otherwise there will permanently be a discrepancy between the two systems.

The most straightforward way to compare the two systems is to use the Xero Journal Exports report in LEAP (Reports > General Account > Xero Journal Exports). This will show the value of the journals exported to any given ledger over any date range. In turn, this is useful to determine whether there have been postings recorded to, or removed from, those ledgers independently in Xero. However, it will not give you the details of the clients/matters involved. To obtain this information, you need to refer to the other LEAP reports for comparison.

Confirm that the accounting basis and your LEAP system is set by clicking the LEAP Menu > Settings > Application Settings> Accounting > General, where it will be set out at the bottom of the page. The accounting basis will change when or whether LEAP exports postings to certain ledgers. As such, where it is appropriate, a ledger may have different comparisons, depending on how the firm has been set in LEAP. There are also three different ways that ledgers can be compared with LEAP.

These are:

Over a given date range
As at a specific date
As at the current date

In each instance, it will be specified how the ledgers can be compared. Any limitations in the comparison will also be set out.

Assets

LEAP Undeposited Funds

This ledger represents the value of cash/check payments received not yet marked as deposited in the bank. There is no report that will show undeposited general account payments received, but in order to reconcile the ledger against LEAP as at the current date, click the LEAP Menu > Accounting > under General Accounting > New Bank Deposit. This will display all currently undeposited entries. If you then select all the entries, the total should match the balance of the LEAP undeposited funds ledger in Xero.

LEAP Debtors

The Debtors ledger represents the value of the debts owed to the firm. This also considers any unallocated retainer balances. This can be compared to the Aged Debtors report as at any date. It also tracks quite closely to the Invoices Report, where the parameters are set to:

Start Date	01/01/2000 (or another date preceding the earliest posting)
End Date	Date being compared to
Invoice	Printed Sent (Final) only
Show Inactive Staff	Yes, with all Staff Acting & Responsible selected
Show Outstanding Invoices Only	Yes

This should be very similar to the aged debtors balance, and provide a greater breakdown of Fees, Disbursements & Tax, but is an imperfect comparison as it will not include retainer balances not allocated to invoices, or where payments received are dated prior to the invoice.

Liabilities

LEAP Tax Collected

When an invoice is raised, the invoice will go over to Xero with the Tax element being held in the Tax collected nominal. In order to reconcile this between LEAP and Xero, go to Reports > General Account > Invoices Report.

Set the following parameters:

Start Date	01/01/2000 (or some other date that precedes the earliest invoice on LEAP)
End date	The date being reconciled to
Outstanding invoices	Yes
Show Inactive Staff	Yes, with all Staff Acting & Responsible selected
Invoices	Printed Sent (Final) only

If you have no part paid invoices (i.e. this report shows nothing in the ‘payments received’ column), then the total value of the Fees Tax & Disbursements Tax columns should match the balance of the LEAP Tax collected nominal.

Where there are part paid invoices, the reconciliation becomes more complicated. A receipt against an invoice is applied to the elements of that invoice proportionally, e.g. if a bill is half paid, then LEAP & Xero will consider half the fees, half the disbursements and half the Tax to be paid. On these cases, you would need to calculate the percentage of the total bill that is outstanding, then apply that percentage to the Fees Tax and Disbursement Tax values for that invoice.

Income

LEAP Client Fees

The LEAP Client Fees ledger will show the value of fees on finalized invoices. This can be reconciled up to any date.

Run the Invoices Report (Reports > General Account > Invoices Report) with the following parameters:

Start date	01/01/2000 (or some other date that precedes the earliest invoice on LEAP)
End date	The date being reconciled to
Invoices	Printed Sent (Final) only
Reversals	Include reversals of invoices transacted outside date range

The Fees (excluding Tax) column in this report will match the LEAP Client Fees ledger.

LEAP Expense Recoveries/LEAP Payments Received

For the purposes of reconciling between LEAP & Xero, these two ledgers are combined and their total value used for comparison.

These ledgers will give the value of the Expense Recoveries and General Account Expenses/Anticipated Expenses (respectively) elements on finalized invoices. This can be calculated up to any date using the Invoices report (Reports > General Account > Invoices Report) with the following parameters:

Start date	01/01/2000 (or some other date that precedes the earliest invoice on LEAP)
End date	The date being reconciled to
Invoices	Printed Sent (Final) only

The Disbursements (excluding Tax) column in this report will match the combined value of the LEAP Expense Recoveries and LEAP Payments Received ledgers.

Expenses

LEAP Discounts Given/LEAP Debtors Write Offs

Between them, these ledgers represent the value of adjustments against finalized invoices. As there are no reports in LEAP that will separate the two different types of adjustments, the value of the two ledgers will need to be combined when comparing with LEAP. This can be done over any date range.

From within LEAP, go to Information in the toolbar and select the Search Transactions option. There will be an option saying Invoices Adjustments. Click this and select your desired date range, then click the Print icon in the upper right. The report that this generates will include a total line in the ‘Debits’ column, which should match to the total of the LEAP Discounts Given & LEAP Debtors Write Offs ledgers.

LEAP Expenses Write Offs

This ledger represents the total value of written off General Account Expenses. This can be reconciled between LEAP & Xero for any date range.

From LEAP, go to the Information drop down from the top of the page and select the Search Transactions option. In the drop down on the left you can select General Account Disbursement and any date range at the top of the page. This report will show any Disbursement Journals (which always have equal debits and retainers) and Disbursement Write Offs. You will be able to print this list using the Printer icon in the top right corner. The printout will have a total debit and retainer balance at the top. The total Retainers less the total Debits will correspond to the balance of the LEAP Expense Write Offs ledger in Xero.

LEAP General Account Expenses

This ledger represents the value of all New General Account Expenses and expenses in relation to Anticipated Expenses, less the value of any Disbursement write-offs. It can be reconciled to LEAP over any date range.

The value of all Expenses (whether standard expenses or expenses in relation to Anticipated Expenses can be ascertained in LEAP from the General Account Expenses report (Reports > General Account > General Account Expenses Report). This would need to be run for each General Bank Account that will have transactions in the date range. You will want to take the total of the Amount Excluding Tax column for each bank and add those together.

To fully reconcile with the LEAP General Account Expenses ledger, you will need to consider the written off general account expenses, which will have reduced the Xero balance. Calculate this balance using the steps from the LEAP Expenses Write Offs ledger above. The LEAP General Account Expenses ledger will match to the General Account Expenses report, less this amount.

General Account Bank

As LEAP is only concerned with transactions that relate to matters, there will be numerous postings that affect the general account bank that are posted in Xero itself and do not get added to LEAP. As a result, the only complete record of the general account can be found in the Xero system.

Your options for comparing the ledger to LEAP would be limited to the General Account Expenses & General Account Payments Received reports (Reports > General Account > General Account Expenses Report/Payments Received Report respectively) though this would, by its nature, not provide the complete transaction history affecting the bank.

Tax

The full Tax balance will almost certainly include Input Tax being reclaimed on several practice expenses. As such it is not possible to reconcile the Tax Ledger with any report in LEAP. However, some comparisons can still be found, in particularly when looking at the Output Tax aspect of the Tax Return, as tax on invoices raised is the primary, if not sole, source of Output Tax.

The Output Tax will correspond to the Tax on finalized invoices. This can be reported on in LEAP using the Invoices Report (Reports > General Account > Invoices Report) up to a specific date.

Set the parameters as:

Start date	1/1/2000 (or a date preceding the earliest invoice)
End date	The date being reconciled to
Include all Staff	Yes
Invoice	Printed Sent (Final) only

The total value of the Tax on Fees & Tax on Disbursements column should correspond to the Output Tax up to that date.

Last Modified Date

16/10/2023 2:02 am

Title

Comparing Xero Balances with LEAP Reports

URL Name

Comparing-Xero-Balances-with-LEAP-Reports-CA

Resolution