Skip to the content
  • 0161 804 0808
  • info@morethanaccountants.co.uk

More Than AccountantsMore Than Accountants
  • Who We Help
    • Sole Trader Accounting
    • Small Business Accountants
    • Limited Company Accountants
    • Partnership
    • Limited Liability Partnerships
    • Contractor Accountants
    • Xero Accountants
  • Online Accountancy Services
    • Company Accounts
    • Tax Returns
    • VAT Returns
    • Bookkeeping Services
    • Financial Reports
    • Payroll Services
  • Knowledge
    • Blog
  • Contact Us

Get A Quote

  • Who We Help
    • Sole Trader Accounting
    • Limited Company Accountants
    • Partnership
    • Limited Liability Partnerships
    • Contractor Accountants
  • Online Accountancy Services
    • Company Accounts
    • Tax Returns
    • VAT Returns
    • Bookkeeping Services
    • Financial Reports
    • Payroll Services
  • Quote Online
  • Blog
  • Contact Us
Categories
Accountancy Software

How to Use Xero’s Cash Coding Tool

  • Post author By James Duffy
  • Post date January 25, 2019
  • No Comments on How to Use Xero’s Cash Coding Tool

Accountants and bookkeepers using the Xero platform have access to an invaluable tool for managing and categorising bank transactions. It is called ‘cash coding’. The cash coding tool is a streamlined, easy-to-use tool that combines a number of useful functions in a single space that is both intuitive and efficient.

The tool allows for importing bank statements in order to facilitate reconciliation one transaction at a time. It is the fastest way to reconcile transactions in bulk from within the Xero software, thus reducing the amount of time the accountant or bookkeeper has to spend on each client’s reconciliation.

Working with the Accounts Page

Table of Contents

  • Working with the Accounts Page
    • Selecting a Range
    • Applying Bank Rules
  • Other Great Features

Reconciling a statement from within the cash coding tool automatically takes you to the ‘Accounts’ page. Here is where all of the client’s accounts are managed. Use the drop-down menu at the top of the page to switch between accounts on-the-fly. All of the transactions requiring reconciliation for the current statement appear on this page.

Want to switch to More Than Accountants? You can get an instant quote online by using the form below. In a like for like comparison for services we are up to 70% cheaper than a high street accountant.

More advanced functions are available to anyone with cash coding privileges. If that’s you, just click on the ‘Cash Coding’ tab next to the ‘Reconcile’ tab near the top of the statement report. You will be presented with a new screen listing all of the transactions on the current statement.

The difference with this page is that transactions are divided into different columns that you can use for sorting purposes. You can sort by payee, description, amount, etc. Best of all, you can perform bulk actions by using the tick boxes next to each transaction.

Selecting a Range

To select a range of transactions to work with, just check the tick box of the first transaction list, hold down the ‘SHIFT’ key, and check the tick box on the last transaction in your range. All the transactions in between will be selected as well. If you make a mistake, click the ‘Uncheck all’ button to clear your selections and start over.

You can modify all of the transactions in a given range just by modifying one of them. For example, let us say you want to modify the description. Just modify the description of the first item in the range. All the other items will be modified instantly, using the same data you just entered.

Applying Bank Rules

Xero allows you to create bank rules for dealing with certain transactions. You can apply those rules from the cash coding tool simply by selecting the transactions in question and clicking the ‘Apply rule’ button at the top of the transaction columns. If you have more than one rule, clicking the button will open a drop-down menu from which you can choose from.

You can apply bank rules on ranges of transactions by following the same process described above. Just select your range and apply the rule using the button or drop-down menu. This is a great timesaver because it saves you the trouble of having to recode individual transactions manually.

Other Great Features

What you have read thus far is really just a basic introduction to Xero’s cash coding tool. It offers a number of additional great features you’re going to love. For example, you can view up to 200 transactions per page. Even the most complex bank statements can be worked through in no time at all with less clicking.

Also note that as long as you are working within the tool the ‘Save and Reconcile’ button constantly remains at the bottom of the screen. You can save as often as you like for your own peace of mind. And when you’re done, one last click finishes the job.

Share this post

By James Duffy

James is the co founder of More Than Accountants an Online Accountants. He will be more than happy to help More Than Accountants clients implement any guides or strategies that he has posted to the blog. If you would like to learn more about becoming a More Than Accountants client you can quote online by using our Unlimited Accountancy Services Quoting Tool.

View Archive →

← 10 Reasons Your Small Business Should Be Using Xero → 4 Ways to Build a Foundation for Marketing

Leave a Reply Cancel reply

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

By James Duffy

James is the co founder of More Than Accountants an Online Accountants. He will be more than happy to help More Than Accountants clients implement any guides or strategies that he has posted to the blog. If you would like to learn more about becoming a More Than Accountants client you can quote online by using our Unlimited Accountancy Services Quoting Tool.

View Archive →
  • 0161 804 0808
  • Get An Online Quote

Registered office :
Burnden House, Viking Street,
BL3 2RR

0161 804 0808
info@morethanaccountants.co.uk

Who We Help

  • Sole Traders
  • Limited Companies
  • Partnerships
  • Limited Liability Partnerships
  • Contractor Accountants
  • Small Business Accountants
  • Xero Accountants
Linkedin Youtube Facebook

Services

  • Company Accounts
  • Tax Returns
  • VAT Returns
  • Bookkeeping Services
  • Financial/Management Reports
  • Payroll Services

Resources

  • Knowledge Base
  • Blog
  • Quoting Tool
  • Accountancy News
  • Accountancy Software
  • Business Funding
  • Business Practice
  • Business Tools and Process Automation
  • Company News
  • Customer Relationship Management CRM
  • Entrepreneurship
  • Industry News
  • Marketing

Recent Blog Posts

Recent Posts
  • Making business accessible to everyone
  • Labour shortages in the UK; how can businesses stymie the great resignation?
  • Understanding supply chains and the challenges they face
  • Growing your business: the different options
  • Economic and business impacts of COVID-19: the biggest shake-up in modern times

© 2021 More Than Accountants Limited 

More Than Accountants is a limited company registered in England under company number 09974015.
Content is for general information only. Always take advice.
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT