On all accounting basis, 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 operating account payments received, but in order to reconcile the ledger against LEAP as at the current date, click the LEAP Menu > Accounting > under Operating 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. 

Cash Basis - On a cash basis LEAP does not create Xero journals when invoices are raised, so this ledger will not be used. 

Accrual Basis – 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:

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. 

Cash Basis Only - The LEAP Debtors Adjustment ledger is only used on a Cash basis where payments received against an invoice has been adjusted. Each series of journals created by an adjustment will create matching debit and retainer values on this ledger, leaving it with a nil balance. There should be no balance to reconcile at any point.

Cash Basis – The LEAP Client Fees ledger will show monies received against fee elements on invoices or where a retainer balance is applied to the invoice. There are several reports that show the value of payments received, but none that will correspond exactly with the transactions in this ledger.

Accrual Basis – 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 > Operating Account > Invoices Report) with the following parameters:

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

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

Cash Basis – These ledgers will record the value of payments received recorded against the Expense Recoveries and Operating Account Expenses/Anticipated Expenses (respectively) elements on finalized invoices. There are no standard reports in LEAP that will specifically isolate payments received against the Disbursements/Expense Recoveries Elements of Invoices from payments received against the Fees.

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

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

Cash Basis Only – The LEAP Client Retainers ledger is only utilized on the Cash basis. It represents the value of operating account bank retainer balances that are not allocated to an invoice. This can be found in LEAP as at any given date using the Matter Balances report (Reports > Operating Account > Matter Balances) when the following parameters are set:

The total value of the Retainers column on the final page will correspond with the LEAP Client Retainers ledger.

Accrual Basis – This ledger is only used on these basis. Between them they 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.

All Basis – This ledger represents the total value of written off Operating 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 Operating 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.

All Basis – This ledger represents the value of all New Operating 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 Operating Account Expenses report (Reports > Operating Account > Operating Account Expenses Report). This would need to be run for each Operating 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 Operating Account Expenses ledger, you will need to consider the written off operating 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 Operating Account Expenses ledger will match to the Operating Account Expenses report, less this amount.

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

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

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.

Cash Basis – the Output Tax will correspond to the Tax on payments received against finalized invoices. This will closely correspond in LEAP to the Tax Column of the Operating Account Payments Received Report (Reports > Operating Account > Operating Account Payments Received). This report can be run for any date range. This comparison is somewhat limited as it will only show payments received, not the application of retainers. If payments received are only recorded after invoices are finalized this should not present an issue.

Accrual Basis – the Output Tax will correspond to the Tax on finalized invoices. This can be reported on in LEAP using the Invoices Report (Reports > Operating Account > Invoices Report) up to a specific date. Set the parameters as:

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