Content
You must first create the Spend Money/Payment using the “Make a Cash Refund” section at the bottom of the OP/PP transaction form. On 15 Feb you invoice the client for services totalling $2000 + GST ($2,100.00). You apply the available credit for $500 and send the invoice for net payment of $1,600.00.
Missing Bank Statement Lines – before bank feed starts – when you set up a bank account in Xero the bank feed data might be missing the first few weeks. You can tell when your feeds started by looking at the Bank Statements tab in the bank account screen and sorting on start date . The easiest way to solve this tis to import the missing data from your bank account and then reconcile these transactions. If you have already manually reconciled then you should check that you have done it correctly. Statement Balance – this is a calculated balance within Xero of all the reconciled transactions plus the un-reconciled statement lines. This is what Xero thinks that you bank statement balance should be based on the information provided to it. To set this up you need to create an account in the Chart of Accounts in Xero.
I’ve been searching around for a way to show all transactions by supplier, so I can see in one report invoices and credit notes received and payments made. This was so easy in MYOB and I’m amazed at how hard it is in Xero. Rectifying this has to be a priority, unless someone can tell me how to do this. For Spend And Receive Money Transactions In Xero example, with Bank Charges, I always reconcile these using ‘spend money’, and then choose ‘To’ ‘Barclays’, or ‘HSBC’ or the relevant bank. However, if I go to view these transactions by viewing Barclays or HSBC as a supplier from the Contacts tab, these spend money transactions don’t show against them.
- For Accounts Receivable we provide tools to allow you to stay on top of when people pay you.
- These reports do seem to include Spend/Receive Money transactions.
- When you create a Spend/Receive Money transaction and attach a contact to the Who field, it does not show up in the Sales or Purchases screens and therefore has no impact on the Customer or Supplier Balance.
- It has been entered into Xero already so there is a green match.
- Generate a Reconciliation Report in Xero for the account, switch to the Bank Statement tab and ensure that the date range covers the same date range as the statement you have .
Greenback automatically syncs itemized transactions from top marketplaces and vendors. Subtra is a powerful SaaS purchase and optimization platform for fast-growing enterprises, operated by our partner account managers and delivered as a managed service. For Accounts Receivable we provide tools to allow you to stay on top of when people pay you.
Xero Spend Or Receive Money
In other words, clicking OK would be correct in this case. This indicates that a bill has been entered in the system for this transaction but has not been paid. Or at least please add a Button/Link to the expense/income report at the Contact page. As it is I have to go to the report page, type in what I think is the relevant time period, find the contact, then and only then I am able to see the report. 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. “Xero” and “Beautiful business” are trademarks of Xero Limited.
I’ll update this after the “Catch Me Up” is done and the next time I stop everything to sit down and screw with the books. Xero is unique in that it provides both the Cash and Accrual view of your transactions. Under the Accrual view you see where your accounts are based on what has been invoiced. The Cash view allows you to see the actual cash movements. You’ll soon learn that timing matters a lot for small business cash flow.
The bank account search will help you locate a transaction on the Account Transactions tab. Any items that are showing as unreconciled are items you’ve recorded in Xero with either a payment of funds or receipt of funds that have not yet been matched to transactions coming in through your bank feed. When I look at the listing under Find & Match I see a Bill for Supplier A that is almost the same amount. In this case it is actually the same transaction but I’ve either paid $0.50 too little or entered the bill incorrectly by $0.50. If I didn’t know I already had a bill in Xero for this transaction it would be very easy just to click OK and let Xero enter it for me.
If you enter a name that’s not already a contact, Xero adds it to your contacts.When you type a name that isn’t in your list of contacts, NEW appears in the To field. It’s a great place to find items that you might have duplicated by mistake.
Entering Purchases In Xero Using Bills Instead Of Spend Money
At this point I would have two transactions for the same expense, my expenses would be overstated on my Profit & Loss report and I’d have a Bill sitting in my Awaiting Payments tab that was in fact already paid. When we receive money and it is allocated to a customer where no customer invoice is generated, it would be very good if we are able to see this receipt in the customer ledger. Currently, if I reconcile these using Spend Money, instead of going into my ‘suppliers’ and creating a bill, then the transactions won’t show on a report if I pull up all transactions for a supplier. There are times when I use ‘Spend money’ or ‘Receive money’ to reconcile transactions, for example if there are Bank Charges paid. Xero displays transactions for which there wasn’t an automatic match and lets you select one or more. Sometimes Xero won’t automatically make a match because the amount that came in from the bank combined two transactions in Xero.
If you are just using Spend Money and Receive Money I urge you to check out Invoicing with Accounts Receivable and Accounts Payable. Now that you have a safe starting point, jump forward one week at a time until you find the point that they are no longer in balance. Go back daily until you find the last day where it balanced. You have now identified the day where there is a problem. Create a Manual Journal (if Xero expects less than there is you would credit Petty Cash; if Xero expects more than there is you would debit Petty Cash) to record the difference. I usually code the other leg to General Expenses – but if the amount is large then you have probably missed a transaction or two.
If you have good records about every bill ever received from a supplier, then you can easily access information about payments made or credit notes applied. If a supplier ever tries to chase you for payment of a bill they claim hasn’t been paid, you can quickly defend yourself. You can save yourself a huge amount of time down the track by having this information easily accessible. Ever wondered if there’s a better way to manage staying on top of supplier bills? Carmen Morris discusses entering expenses as Bills in Xero and the benefits this offers.
Open in invoice/bill and see the payment history beneath the total. If you can find the erroneous payment you should consider using “remove and redo” on the payment which will free up the invoice/bill for allocation again. Once batch payments are in use, suppliers can receive remittances at the click of a button. They’ll receive something that looks like a statement showing a list of bills paid and the date that you have paid.
You are likely to need more than one line in the transaction so you will need to click “Add Details” to get to the full screen. You should enter each disbursement or receipt as a separate line and code them appropriately.
Creating A Petty Cash Account
But the reality is that this does not always happen. To set this up you need to create a new bank account in Xero. It doesn’t matter what bank or account number you say the account is with as you will not be setting up bank feeds (you can just enter “Petty Cash” as both the bank name, account name and the bank account number). This is the most comprehensive method but also gives the best visibility and is bookkeeping more likely to get sales tax transactions appearing in the correct period on the sales tax reports. The Xero web site also has some guidance on this. Xero has a “secret” transaction type (two – in fact) that many users aren’t aware of, and those that do often mis-use. These transaction types are actually variations of the standard Spend/Receive Money bank transaction but they have very unique treatments.
Overpayments are ideally suited for recording those times when your customer pays you twice, and you will hold the funds to be applied against a future invoice. You can not change the coding or tax treatment in any way. No revenue will be recorded, your Accounts Receivable balance will reflect that you owe the money to the customer, and the payment will show up as a single line on the customer statement. When using a Prepayment you need to specify a ledger code. When you create a Spend/Receive Money transaction and attach a contact to the Who field, it does not show up in the Sales or Purchases screens and therefore has no impact on the Customer or Supplier Balance. Overpayment and Prepayments do have an impact on the Customer/Supplier account – but each in completely different ways. They have the same performance whether Spend or Receive Money – but will impact Supplier accounts/Bill or Customer accounts/Invoices respectively.
Start with the oldest date that you know there was a problem. Generate a Reconciliation Report in Xero for the account, switch to the Bank Statement tab and ensure that the date range covers the same date range as the statement you have . Missing Bank Statement Lines – after bank feed starts – this is somewhat common with Yodlee feeds, unfortunately, and also very hard to find. The only option is to compare your Xero generated statement to the physical statement – see below.
Offsetting Receivables Invoices And Payables Bills In Xero
Generate an Account Transactions report for the Petty Cash account. What is important is that you check the “Enable Payments to this account” box in the Account Details. These transactions types are only valid in the Business editions of Xero and therefore are not available in the Cashbook or Ledger editions. If you need to refund either an Overpayment or a Prepayment you cannot simply match a Bank Statement line against the OP/PP transaction or code a Spend Money.
By having more expenses in the current financial year, the business can declare less profit and therefore needs to pay less tax. Over the long run it makes no difference to the total amount of tax paid, but it’s worth remembering that a dollar today is worth more than a dollar a year from now. The disadvantage of entering Spend Money transactions is that most people rarely enter the supplier bill number, largely because this is absent from the bank feed window unless you click a few more buttons. Also, if you’re paying multiple invoices at once, you can’t enter a single, unique reference number. Entering each individual supplier bill as a Bill in Xero will prevent you from entering a duplicate, as Xero will warn you if you attempt to enter the same bill number twice. Just be mindful that if you have multiple people entering bills in your business that everyone enters them the same way.
If there and not reconciled you should mark it as reconciled. If not there you should create it and mark it as reconciled. Balance in Xero – this is the accounting ledger balance. It is the sum total of all the debits and credits recorded in the bank account in Xero, whether reconciled cash basis to the bank statement or not. By entering Bills, the Profit & Loss report will show the expense on the day that it was incurred, not when it was paid. You can be deceived into thinking that things aren’t as bad as they really are. Secondly, tax deductions can legally be claimed sooner.
Description -This field is optional.Enter as much text as you’d like to describe what your Spend Money transaction is for. You can apply line breaks within the description field by using Enter. The transaction amounts are slightly off so Xero can’t find a match.
Contact Us
If you want to see more information about a particular transaction, drill into the line to open up a detailed view of that transaction. This will give you an Options drop down where you can remove and redo the transaction or you can reconcile or you can reconcile or unreconciled the transaction as needed. If you want to remove and redo a transaction, simply clock the box alongside the account transaction and select “Remove & Redo”. Select this and now you can search for your transaction by either the description or contact name, an amount or the date. You should make sure that you periodically check the Suspense account to ensure that your Invoice payments match the Bill payments (or your accountant will have extra work to do at year-end). Sign up now and we’ll get you up to speed with Xero – simple and intuitive cloud accounting software.
You can even create one from the Find & Match screen by clicking on New button and changing the “Received/Spent as” option. Once you navigate to the bank rule screen, there are 7 areas that need to be filled out for bank rule to work adjusting entries in Xero. Navigate to the Rules Section and Create a rule-This works well if you are trying to create a large number of bank rules at once. A bank rule is used to categorize an expense or deposit that you incur over and over.
If a statement balance is not available for that ending date Xero does not display this line on the Reconciliation Report. Now your Xero account balance should agree with your physical cash. The Spend Money and Receive Money options in Xero can be used to record cash transactions. As you can see, the Prepayment type is far more complicated. It is specifically designed to manage the Sales Tax implications of receiving funds as many jurisdictions treat the movement of cash as the trigger for recognising sales tax liability .