As discussed in the Xero posting methods section, Lightspeed Accounting supports three posting methods. The following article discusses the banking implications in Xero for each posting method. Where appropriate, we have provided links to relevant help articles on Xero's Support site as well.
Xero Journal Entry
When using the journal entry posting method, most customers will use one or more clearing accounts in order to accept the deposits as reported on their Xero bank feed.
A typical example would be something like:
- Cash on Hand
- Due from Merchant Services
- Due from Third Parties (for example, Groupon, manufacturer's coupons, GrubHub, etc.)
As Xero does not allow direct integration with account types in Xero that are Banks, each of the above would be defined in Xero as Current Asset account types.
Using this approach, you will not attempt to match individual transaction as they clear your bank account. Rather, you would monitor the balance in the clearing account(s) to ensure that the balance is clearing itself over time.
As your sales are processed from your POS, the balances in the respective clearing accounts will increase. Then, as you add/accept the actual deposits that Xero reports on your bank feed, you would accept the deposit against the appropriate clearing account.
You can also establish Bank Rules in Xero to automate the assignment of the correct clearing account and contact information.
Lightspeed Accounting will be posting expected bank transactions to your clearing account(s); whereas, the Xero bank feed will be posting what has actually occurred at the bank; which you would process from the Xero bank reconciliation module as follows:
Using this approach, generally speaking, your balances should represent the following:
Cash on Hand: the balance in this account will be the amount of cash you have collected from sales at your store which has yet to be deposited at your bank (or has been deposited but not yet credited to your available funds balance).
- Due from Merchant Services: the balance in this account should represent the amount of sales collected on credit cards for which you have not yet been paid by your merchant services processor, for example, your most recent 1 or 2 days of credit cards processed (depending on your processor and weekends and holidays).
NOTE: If your processor is netting their fee from your deposits, you will need to select the Add details link in the bank transaction to input multiple lines of accounting against a single deposit as follows:
When saved, the above transaction will post an accounting credit to the due from account, an accounting debit to the fee account, and an accounting debit to the bank account for the net amount of the actual deposit.
When using the Summary Invoice posting method, customers have the option of using clearing accounts just as in the Journal Entry. Using this option, the Lightspeed Accounting accounting process will create a net zero invoice with the payments received posting as individual lines on the invoice but as negative amounts. For example, the sales on the invoice will be offset by the payments received for those sales, resulting in a net 0 invoice. The banking processing would be identical to the journal entry method.
Xero Invoice with Separate Tender Deposits:
If a customer wishes to try to match (reconcile) each tender deposit as they are processed on the Xero bank feed, they can use the Separate Deposit feature contained in the Payments portion of their mapping configuration.
The above configuration will create three Xero Invoices
1). A sales invoice that is fully paid and netted against the clearing account designated by the user in their general settings for accounting.
Note that the invoice below nets the total sales (plus taxes, less discounts, etc.) against the designated clearing account.
Additional invoices are also created for each tender type designated as a "Separate Deposit." In this case, all credit cards will create one invoice and cash will create another. These invoices are "plugged" against the same clearing account as the sales invoice so that the clearing account will net to 0 for a given sales date.
Credit card invoice:
The above invoices will create an outstanding entry to the customer's Accounts Receivable account and will also make the above tenders (payments) invoices available for matching in the Xero Banking module, rather than adding/creating them as in the clearing account approach.