Skip to Content
Consol
  • About Us
  • Services
    Accounting

    Our Starter, Lite, and Premium Accounting Plans are for GST and Non-GST registered small businesses.

    Bookkeeping

    Working to your schedule, our certified Bookkeepers help you stay on top of your financial records.

    Payroll

    Our dedicated payroll specialist will process your payruns and ensure your payroll needs run smoothly every time.

    Audit Protection

    We believe in offering our clients smart financial advice and helping them protect their company in case of audit.

    Virtual Finance Team

    Our Virtual Finance Team provides the assistance and advice of a financial department at cost-effective prices. 

    Mortgage & Insurance

    Everyone deserves a chance to make their business and home ownership dreams a reality. Our knowledgable advisors help you find the right solution and protect your investment.

  • Resources
    • Xero
    • Blog
    • FAQs
  • Contact
  • Testimonial
  • About Us
  • Services
    Accounting

    Our Starter, Lite, and Premium Accounting Plans are for GST and Non-GST registered small businesses.

    Bookkeeping

    Working to your schedule, our certified Bookkeepers help you stay on top of your financial records.

    Payroll

    Our dedicated payroll specialist will process your payruns and ensure your payroll needs run smoothly every time.

    Audit Protection

    We believe in offering our clients smart financial advice and helping them protect their company in case of audit.

    Virtual Finance Team

    Our Virtual Finance Team provides the assistance and advice of a financial department at cost-effective prices. 

    Mortgage & Insurance

    Everyone deserves a chance to make their business and home ownership dreams a reality. Our knowledgable advisors help you find the right solution and protect your investment.

  • Resources
    • Xero
    • Blog
    • FAQs
  • Contact
  • Testimonial
0800 001 851
Book A Call
Consol
  • About Us
  • Services
    Accounting

    Our Starter, Lite, and Premium Accounting Plans are for GST and Non-GST registered small businesses.

    Bookkeeping

    Working to your schedule, our certified Bookkeepers help you stay on top of your financial records.

    Payroll

    Our dedicated payroll specialist will process your payruns and ensure your payroll needs run smoothly every time.

    Audit Protection

    We believe in offering our clients smart financial advice and helping them protect their company in case of audit.

    Virtual Finance Team

    Our Virtual Finance Team provides the assistance and advice of a financial department at cost-effective prices. 

    Mortgage & Insurance

    Everyone deserves a chance to make their business and home ownership dreams a reality. Our knowledgable advisors help you find the right solution and protect your investment.

  • Resources
    • Xero
    • Blog
    • FAQs
  • Contact
  • Testimonial
  • About Us
  • Services
    Accounting

    Our Starter, Lite, and Premium Accounting Plans are for GST and Non-GST registered small businesses.

    Bookkeeping

    Working to your schedule, our certified Bookkeepers help you stay on top of your financial records.

    Payroll

    Our dedicated payroll specialist will process your payruns and ensure your payroll needs run smoothly every time.

    Audit Protection

    We believe in offering our clients smart financial advice and helping them protect their company in case of audit.

    Virtual Finance Team

    Our Virtual Finance Team provides the assistance and advice of a financial department at cost-effective prices. 

    Mortgage & Insurance

    Everyone deserves a chance to make their business and home ownership dreams a reality. Our knowledgable advisors help you find the right solution and protect your investment.

  • Resources
    • Xero
    • Blog
    • FAQs
  • Contact
  • Testimonial
0800 001 851
Book A Call
Consol
  • About Us
  • Services
    Accounting

    Our Starter, Lite, and Premium Accounting Plans are for GST and Non-GST registered small businesses.

    Bookkeeping

    Working to your schedule, our certified Bookkeepers help you stay on top of your financial records.

    Payroll

    Our dedicated payroll specialist will process your payruns and ensure your payroll needs run smoothly every time.

    Audit Protection

    We believe in offering our clients smart financial advice and helping them protect their company in case of audit.

    Virtual Finance Team

    Our Virtual Finance Team provides the assistance and advice of a financial department at cost-effective prices. 

    Mortgage & Insurance

    Everyone deserves a chance to make their business and home ownership dreams a reality. Our knowledgable advisors help you find the right solution and protect your investment.

  • Resources
    • Xero
    • Blog
    • FAQs
  • Contact
  • Testimonial
  • About Us
  • Services
    Accounting

    Our Starter, Lite, and Premium Accounting Plans are for GST and Non-GST registered small businesses.

    Bookkeeping

    Working to your schedule, our certified Bookkeepers help you stay on top of your financial records.

    Payroll

    Our dedicated payroll specialist will process your payruns and ensure your payroll needs run smoothly every time.

    Audit Protection

    We believe in offering our clients smart financial advice and helping them protect their company in case of audit.

    Virtual Finance Team

    Our Virtual Finance Team provides the assistance and advice of a financial department at cost-effective prices. 

    Mortgage & Insurance

    Everyone deserves a chance to make their business and home ownership dreams a reality. Our knowledgable advisors help you find the right solution and protect your investment.

  • Resources
    • Xero
    • Blog
    • FAQs
  • Contact
  • Testimonial
Book A Call
Consol
  • About Us
  • Services
    Accounting

    Our Starter, Lite, and Premium Accounting Plans are for GST and Non-GST registered small businesses.

    Bookkeeping

    Working to your schedule, our certified Bookkeepers help you stay on top of your financial records.

    Payroll

    Our dedicated payroll specialist will process your payruns and ensure your payroll needs run smoothly every time.

    Audit Protection

    We believe in offering our clients smart financial advice and helping them protect their company in case of audit.

    Virtual Finance Team

    Our Virtual Finance Team provides the assistance and advice of a financial department at cost-effective prices. 

    Mortgage & Insurance

    Everyone deserves a chance to make their business and home ownership dreams a reality. Our knowledgable advisors help you find the right solution and protect your investment.

  • Resources
    • Xero
    • Blog
    • FAQs
  • Contact
  • Testimonial
  • About Us
  • Services
    Accounting

    Our Starter, Lite, and Premium Accounting Plans are for GST and Non-GST registered small businesses.

    Bookkeeping

    Working to your schedule, our certified Bookkeepers help you stay on top of your financial records.

    Payroll

    Our dedicated payroll specialist will process your payruns and ensure your payroll needs run smoothly every time.

    Audit Protection

    We believe in offering our clients smart financial advice and helping them protect their company in case of audit.

    Virtual Finance Team

    Our Virtual Finance Team provides the assistance and advice of a financial department at cost-effective prices. 

    Mortgage & Insurance

    Everyone deserves a chance to make their business and home ownership dreams a reality. Our knowledgable advisors help you find the right solution and protect your investment.

  • Resources
    • Xero
    • Blog
    • FAQs
  • Contact
  • Testimonial
Book A Call

How may we help you?

Back to FAQs

Xero

  • Do you have useful Xero coding tips?
  • What do I get in a Xero accounting software subscription?
  • How do I handle transfers between bank accounts?
  • What code do I use for equipment purchases?
  • How do I add home office expenses in Xero?
  • How do I change the account code on a reconciled transaction?
  • How do I reconcile a payment for multiple invoices?
  • How do I reconcile a partial payment on an invoice?
  • How do I code small differences between what was invoiced and what was paid?
  • How do I code refunds I receive?
  • How do I code money I put into or take out of the business?
  • How do I code a prepayment from a customer?
  • How do I code an overpayment from a customer?
  • How do I code entertainment expenses?
  • How do I record GST payments or refunds from IRD in Xero?
  • How do I claim GST on overseas purchases and imports?

How do I code an overpayment from a customer?

For example, if a customer pays $450 on a $400 invoice, they have overpaid by $50.

  • On the reconciliation screen click Find and Match on the payment of $450.
  • Tick the invoice for the payment, the total should be off by $50
  • Create new transaction by clicking the +New button and select Receive Money
  • Click where it says Direct Payment and change it to Overpayment
  • If the contact name in From is not correct, change it
  • Type in $50 as that is the amount that is overpaid, check that it is correct, and click Save Transaction.
  • On the Find and Match screen, both the $400 of invoice and $50 of overpayment should be selected, adding up to $450. Click the reconcile button.


The payment is now reconciled. The overpayment of $50 recorded is a special type of credit note that is in the Account Receivable/Awaiting Payment, and the next time you invoice the same customer the system will ask you if you want the credit to be applied.

The overpayment can also be refunded under the credit note/Make a cash refund section. Enter in the refunding amount, the date you are making the refund, and the bank account it will be paid from. Click Add Refund, then the refund paid should go into the reconciliation screen and match the overpayment credit not.

Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on March 11, 2022
How do I code a prepayment from a customer?How do I code entertainment expenses?

Powered by BetterDocs

Illustration_Footer_695x564px
new zealand online accounting company consol main latina logo

Integrated with

about consol

  • About Us
  • Why Choose Consol
  • Contact Us

services

  • Accounting
  • Bookkeeping
  • Payroll
  • Audit Protection
  • Virtual Finance Team
  • Mortgage & Insurance

resources

  • FAQs
  • Blog
  • Xero

socials

  • LinkedIn
  • Facebook
  • Instagram
  • Terms and Conditions
  • Privacy Policy

Copyrights © Consol Accounting Limited 2022

Cleantalk Pixel