Reconciling Part Payments and Multiple Invoices with Xero WK Advisors and Accountants

Read on to discover the steps to recording a part payment during reconciliation. With the ability to split payments, the possibilities are endless! Use this feature to record partial receipts from customers, partial or advance payments to vendors. Pay off multiple bills using one payment instead of sending multiple checks.

splitting payments to reconcile expenses in xero

Multiple invoices paid with a single transaction

  • You may have even made a partial payment to your suppliers before.
  • The remaining balance will still be reflected on the respective invoice, bill, or expense claim, allowing for reconciliation with the next payment.
  • Have you ever received a bill that you would like to partially pay?
  • In cases where the related invoice, bill, or expense claim hasn’t been generated yet, opt for recording a prepayment.

Synder makes this easy by automatically calculating COGS and syncing everything seamlessly with Xero. Here’s how Synder helps you sync eBay managed payments with Xero, providing automated reconciliation, precise fee tracking, and minimal manual work. In the split transaction screen enter the amount that you want to pay off this specific invoice. The amount should pre-populate based on the bank transaction line but can be changed easily if required. Check out this article on how to copy invoices to save time on data entry. You can find transactions entered for money you’ve both spent and received, by selecting the checkbox Show Received Items or Show Spent Items.

The remaining balance will still be reflected on the respective invoice, bill, or expense claim, allowing for reconciliation with the next payment. Alternatively, you have the option to directly record a partial payment on an invoice, bill, or expense claim. During the bank account reconciliation process, the payment transaction will appear as a suggested match. If recorded the partial payment using this method, it’s not possible to modify the allocated amount for each invoice, bill, or expense claim during reconciliation. If the payment has been applied incorrectly, you’ll need to delete the payment from the transaction and re-enter it with the correct details.

How can I break down the eBay settlement (sales, fees, shipping, refunds) properly in Xero?

Select the first invoice you wish to apply the deposit against (INV-0043 for $1,800.00). Notice that when you select the transaction, a blue hyperlink called “Split” appears. On the bank reconciliation screen, next to the bank statement line you want to reconcile, click Find & Match.

  • Xero allows business owners to navigate these challenges successfully with the ability to apply split payments against both invoices and bills.
  • Xero will then ask you how much of the deposit you wish to apply towards this invoice.
  • Here’s how Synder helps you sync eBay managed payments with Xero, providing automated reconciliation, precise fee tracking, and minimal manual work.
  • Synder records detailed settlement data, like sales, fees, shipping, refunds, and taxes in a clearing account.

Recording the part payment during reconciliation

Once the partial payment has been applied, you will notice that the invoice is moved to the lower half of the Reconciliation Window. Xero provides us with the remaining amount needed to balance this transaction to the bank feed. In cases where the related invoice, bill, or expense claim hasn’t been generated yet, opt for recording a prepayment. Additionally, if a customer unintentionally overpays or you accidentally make an excess payment to a supplier, document it as an overpayment. If we select the second invoice to be paid (INV – 0042 for $200.00), the reconciliation window updates to let us know that this transaction is now OK to match. Select Reconcile at the bottom to match the transactions to the bank feed.

Step 4: Import product costs

With Auto-reconcile enabled, Synder automatically marks these transactions as reconciled in the clearing account, leaving your checking account untouched until you match payouts. Since Xero doesn’t allow third-party apps to reconcile Bank Transfer payouts, eBay settlements will sync as Unreconciled and require a quick manual reconciliation in Xero. If you need to delete or roll back payouts, simply remove them directly in Xero, as Synder as Synder cannot delete them on your behalf. Step-by-step instructions for how to reconcile partially paid invoices, bills or expenses claim and multiple invoices paid at once with Xero. Synder records detailed settlement data, like sales, fees, shipping, refunds, and taxes in a clearing account. You then reconcile payouts from eBay with this account to keep everything accurate and separated.

If you want to reconcile eBay payments in Xero quickly, accurately, and without the usual headaches, the most effective solution is to use an integration tool like Synder. Sometimes, out of convenience, you or your customers may pay multiple invoices with a single transaction. Follow the below process to find multiple transactions and reconcile with a statement line. Have you ever received a bill that you would like to partially pay? What should you do if you receive a partial payment from a customer? Xero allows business owners to navigate these challenges successfully with the ability to apply split payments against both invoices and bills.

Step 2: Turn on auto-reconcile in Synder

During setup, choose or create the right expense accounts, and Synder automatically maps each fee type correctly. Xero will then ask you how much of the deposit you wish to apply towards this invoice. In this example, we want to pay this invoice in full, splitting payments to reconcile expenses in xero so we would enter the amount equal to the invoice and then select Split. Find and select the checkbox next to the invoice, bill or expense claim that you want to match with the bank statement line.

How to auto-reconcile eBay payments in Xero with Synder

Whatever your customer’s reason — a shortage of cash, a dispute with items on the invoice, or an incorrect payment amount — you’ll likely receive part payment of an invoice from time to time. You may have even made a partial payment to your suppliers before. Synder offers flexible summary modes, allowing you to choose between daily aggregation, per-payout synchronization, monthly summaries, or even custom date ranges. If you select Summary Sync, Synder combines all eBay sales, fees, refunds, taxes, and discounts into a single record for each day. Synder streamlines your eBay bookkeeping by creating a clearing (holding) bank account in Xero to temporarily store synchronized income and expense transactions. If part payments are being paid or received, it’s important to account for them correctly to keep your financials balanced.

Quick fixes 20 – How to split payment under reconciliation on Xero

In the example below, let’s say you received one payment from Jakaranda Maple Systems that needs to be applied towards two invoices. Once product costs are imported, Synder automatically calculates COGS for all newly imported daily summaries. For each sale, the software multiplies the quantity sold by the product’s imported cost, debiting the COGS account and crediting the inventory asset account accordingly. COGS (cost of goods sold) are the direct costs of producing or purchasing the goods you sell. Accurately tracking COGS and inventory for your eBay sales in Xero is very important to understanding your true profits and keeping your books organized.

Leave a Comment

Your email address will not be published. Required fields are marked *