How to Reconcile Your Account in Xero – Part 2, Cash Coding

Written By

This is the second part of a Xero training on reconciling your account. In this part, I’ll show you how to use the Cash Coding method.

Click here to read part one.

Quick Instructions:

  1. On the dashboard click a blue Reconcile link in a bank accounts tile
  2. Click the Cash coding tab at the top of the screen
  3. Edit fields for items in the list
    1. Payee (optional to edit)
    2. Account
    3. Tax Rate (updates automatically)
  4. Check off all items you’ve edited and want to reconcile
  5. Click the green Save & Reconcile Selected button on the bottom of the screen

Keep reading for full instructions with screenshots.

Let’s continue our reconciling from Part 1 using the Cash coding tab. This tab is at the top of the screen to the right of the Reconcile tab.

Cash Coding tab in a Xero bank account

This is a different method that you can use to reconcile your transactions.

On this screen, you’ll see a list of your transactions looking like a spreadsheet.

Cash Coding tab in Xero

You can click on any of the fields in this list to edit them. I’ll start with the first item on my list, a DreamHost expense. 

First I’ll update the Payee field and removing the extra text and changing it to just “Dreamhost.” Under account, I’ll click the drop-down menu. Then select an expense account for this transaction. The Tax Rate field is automatically filled in after I select the account type.

Reconciling transactions in Xero on the Cash Coding tab

Once you’ve edited several items click their checkboxes to the left.

Checking off editing transactions on the Cash Coding screen in Xero

Then click the green Save & Reconcile Selected button on the bottom of the screen.

A pop-up will appear letting you know how many items you reconciled.

Completed reconciling pop-up when using Cash Coding in Xero

You now know how to reconcile your accounts in Xero. If you have any questions about reconciling accounts in Xero please ask them in the comments.

☕ If you found this helpful you can say “thanks” by buying me a coffee…
https://www.buymeacoffee.com/gentlefrog

If you’d like to watch me walk through this process check out the video below:

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

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

Read similar articles

Deleting Data from QuickBooks Online Using SaasAnt

Learn how to delete data from QuickBooks Online with SaasAnt.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.