Match bank statement lines

A deposit in your bank rarely lines up with a single order. An Amazon settlement or a Shopify payout pays out many orders less fees, and a supplier payment can settle several bills at once. Statement Match reads the lines of your bank statement and finds the SKU.io documents that each line settles. You confirm the matches, then push the documents to Xero so its bank reconciliation has everything it needs.

Before you begin

• Connect Xero. Statement Match reads lines from Xero's bank screens, so the lane only appears when a Xero connection is active. QuickBooks Online connections don't show it.
• Have the lines you want to match open in Xero, on its bank reconciliation or cash-coding screen.

Read the statement lines in

Xero doesn't let other apps read raw bank statement lines, so you give SKU.io a screenshot and SKU.io reads the lines off the image.

1. In Xero, take a screenshot of the bank statement lines you want to match.

2. In SKU.io, go to Accounting → Reconciliation and open the Statement Match lane.

   

3. Paste the screenshot with ⌘V (Ctrl+V on Windows), drag it onto the drop zone, or click the drop zone to choose the file. It must be a PNG, JPG or WEBP image of 10 MB or less.

4. Wait while SKU.io reads the lines. The page reads Reading the statement lines and you can follow progress in the job tray. If the image can't be read, the page says Couldn't read this statement. Paste a clearer screenshot to try again.

When reading finishes, the page shows how many statement lines it found, with In and Out totals. Each line has its Date, Description, Reference, Direction (Money in or Money out), the Spent or Received amount, and a SKU match column. Earlier screenshots stay listed under Recent extractions, so you can come back to them.

Find the matches

1. Click Find SKU matches. SKU.io looks for the documents each line settles and fills in the SKU match column. After the first run the button reads Refresh matches.
2. Read each line's SKU match:
   • One suggestion shows inline with a Match button.
   • Several suggestions show as n matches. Open the menu and pick the document, or set of documents, the line settles.
   • No match means nothing in SKU.io fits the line.
3. Click Match to confirm a suggestion. To confirm every line that has exactly one clear match in one go, click Match all.
4. If a suggestion is wrong, click the ✕ next to it (Not a match). SKU.io won't suggest that document for that line again. You can restore dismissed suggestions from the line.

Use the Show chips, All, Unmatched, To push and In Xero, to work through the list, and the search box to find a line by its text, reference or supplier.

What a line can match

Line	It can match
Money in	A sales order invoice, a batch invoice, a vendor credit, a whole Amazon settlement, or a whole Shopify payout
Money out	A supplier bill, a purchase order invoice, a sales credit, or a group of bills from one supplier that add up to the payment

The rules SKU.io follows:

• The amount must agree to the cent. A settlement, payout or group of bills is only offered when its documents add up to the line exactly. When they don't, the Match button stays disabled and the breakdown shows how far short the documents are.
• Money in looks 60 days either side of the statement date. Money out has no date limit, because suppliers are often paid long after the bill date.
• A supplier named on the line ranks first. Those suggestions carry a Named on line chip.
• Each document settles one line. Once you match a document, SKU.io doesn't offer it for another line.

For a matched settlement, payout or group, the breakdown lists every document in it and confirms that the total matches the deposit.

Push the matches to Xero

1. Click Push to Xero on a line, or Push all to Xero to push every matched line. SKU.io sends any matched document that isn't in Xero yet.
2. Watch the line's status: Pushing… while documents are on their way, then In Xero once every document on the line is there.
3. If a line shows Can't sync, one of its documents is blocked from syncing, for example because of an unmapped account. Fix that document, then push again.

To undo, click the ✕ on a matched line (Unmatch), or Unmatch all. Tick several lines to match, push, or clear them together.

Statement Match doesn't reconcile the bank account inside Xero. It makes sure the documents behind each deposit exist there and add up, so you can finish the reconciliation in Xero.

Next steps

• Sync payments with your accounting provider: record a payment once and see it on both sides.
• Map Amazon settlements to your accounts: post settlements so they can be matched to the deposit.
• Account for Shopify and eBay payouts: post payouts that equal the bank deposit.