Chapter 7
IN THIS CHAPTER
Finding your way around the Purchases dashboard
Creating, approving and cancelling bills
Recording and scheduling payments
Getting a handle on more advanced payment options
Processing expense claims and using the advanced Xero Expenses feature
I work with a client who leads an active and generous life. While she often posts funny photos of herself on Facebook, showing her enjoying her next crazy adventure, she has always worked hard — really hard! She sent her kids to private school, owned a lovely house and led an enviable life — and then, in a matter of a few months, lost everything. What happened? It sounds very simple, but she lost track of the bills. She overlooked paying suppliers, and soon unpaid suppliers stopped providing stock — and she was no longer able to run her business.
Inspirationally, the story has a great ending. She refocused her energies on understanding her numbers, took over the bookkeeping, and embraced her business reports. Over time, she repaid her debts — all of them — and slowly rebuilt her business. She’s now re-engaged a bookkeeper; however, at any point in time, she prides herself on knowing exactly how much money she owes her suppliers.
Xero can help you avoid the same pitfalls. In this chapter, I provide everything you need to understand your own debts, starting with working your way through Xero’s Purchases dashboard. I provide tips on utilising purchase orders, keeping track of bills and paying them in a timely manner, and finish off with advice on entering your expense claims into Xero.
If all your bills are processed through the Purchases area (see the nearby sidebar ‘Understanding your records’ for more on this), the first thing you need to know to manage your payables is: What do I owe? Xero gathers all that information on the Purchases dashboard, which you can access from the home dashboard by clicking Business → Purchases Overview. (Figure 7-1 shows the Purchases dashboard, highlighting the features that are available if you process all bills through the purchases area.)
If you process all bills through Xero’s purchases area, the Purchases dashboard is split into three blocks: Buttons, menu bar and a bar chart.
The first block of the Purchases dashboard contains three buttons: New, Import and Search. The New button allows you to click through to create a New Bill, Repeating Bill, Credit Note and Purchase Order. The Import button begins the import process (covered in Chapter 3).
Clicking on the Search button opens the search pane. Here you can enter an amount, reference, contact name and/or dates criteria to search for bills or purchase orders.
The second block of the Purchases dashboard contains seven tabs: Paid, Repeating, See All, Draft, Awaiting Approval, Awaiting Payment, and Overdue. Here’s how you can explore this area:
Click on Business → Purchases Overview to return to the high-level view of the Purchases dashboard. The third block of the Purchases dashboard contains a bar chart displaying Upcoming Bills, representing the current net monthly outstanding bills determined by the due date. In other words, it highlights outstanding creditors. Paid bills are indicated by green bars, with cyan indicating unpaid bills. Underneath the chart is a stretch bar.
Here are some ways you can explore the bar chart and stretch bar of the Purchases dashboard:
The mining boom brought many interesting businesses to Brisbane, Australia (where my business is based). One such business, and a client of mine, is an export business that helps other businesses source large pieces of mining equipment. Everyone in the office speaks French, they make the strongest coffee imaginable, and they tell me where to find authentic French food in Brisbane. (You may be surprised to find out that Brisbane has a thriving French community!) For this business’s owner, monitoring current and future purchases is a critical part of running his business. It helps him forecast cash flow expenditure and claim back consumer tax in a timely manner.
The life cycle of a bill in Xero can include being created as a draft, being submitted for approval, awaiting approval, being approved, awaiting payment and, finally, applying payment. Xero also allows you to skip these steps and jump straight to the approval stage (or your bill starts off as a purchase order and, once approved, it can be copied into a bill). The following sections cover each of the basic stages. I also cover how to generate a purchase order, which you can use to detail agreed spends for products or services.
When you receive an invoice for payment, you need to ‘create’ that invoice as a bill in Xero. Follow these steps to create a new bill within Xero:
Go to the Purchases dashboard by clicking Business → Purchases Overview and select + New.
The New Bill window appears (see Figure 7-2).
Enter the contact name in the From field.
If the supplier is already in your Xero file, start typing the contact name and Xero autosuggests contact names and their associated primary contact person’s first name, last name and email address. Select the relevant contact, or type in the name of a new contact. (Refer to Chapter 5 for guidance on adding Contact details.)
If an existing unbilled purchase order has been assigned to the supplier, a notification appears above the bill, and you can save time by bringing the purchase order details into a bill. If there’s a single unbilled purchase order, click the blue Copy Line Items hyperlink, and at the Copy Purchase Order to Bill window, check the box Mark as Billed and click the green OK button. If there are multiple unbilled purchase orders, select View as a List and a new tab on your browser opens at the Purchase Orders dashboard, where you can select the purchase order you may want to convert to a bill. Discard the original bill you were working with. See the section ‘Generating a purchase order’, later in this chapter.
Enter the Date in the date calendar box.
Today’s date automatically appears; you should override this with the actual bill date, if it’s different.
Enter the optional bill Reference field.
Purchase bills are not automatically numbered. You can use the text field for a mnemonic reference, or to repeat the supplier bill number or the name of the contact who issued the bill.
Attach the bill to the transaction via the document symbol.
If you received a hardcopy version of the bill, you need to scan the bill to then attach it as a separate file. If you received the bill via email — perhaps as an attached PDF — you can simply forward the email to your unique bills email address, and it will automatically attach to a draft bill. Your unique Xero bills email address is found on the top right corner of the Purchases dashboard. This creates a Draft bill, so at Step 1 you would open the draft bill rather than create a new bill. The copy of the bill is stored in a retrievable format.
Many countries allow records to be stored in digital format, and the practice is environmentally friendly too! Just check with your country’s tax regulations to make sure maintaining digital records is acceptable.
Select the bill currency from the drop-down Currency field options.
Enter the total bill amount in the Total field.
If left blank, the Total field autofills the first time the bill is saved. If you subsequently update the transaction, you need to manually change the Total field.
Select the consumer tax status of the bill from the drop-down Amounts Are field options.
The three options are Tax Exclusive, Tax Inclusive and No Tax (refer to Chapter 6 for an explanation of these options).
Enter or select the inventory item from the optional Item field.
To add text from the supplier’s last recorded bill in Xero, click the hyperlink Add Last Item under the Contact field. You can edit them when the lines appear on the bill. A message appears momentarily at the top of the screen with the option to undo this action — but you have to be quick to click on it!
The other fields populate with the item details. See Chapter 13 for guidance on setting up inventory items.
Enter a comprehensive narrative in the mandatory Description field.
Include as much information as possible, such as dates, contacts, work completed and/or items supplied. Keeping serial numbers and warranty information here is also useful for future reference. Because this field is mandatory, if you’ve nothing to say just add a full stop.
Fill in the Qty and Unit Price fields.
Note: If you enter an amount in the quantity field, you must also fill out the Unit Price field.
If the sale is for a fixed-price product or a service, enter the quantity as 1, and the full price in the unit price column.
Enter the account name or number and select the desired account from the suggested drop-down list for the Account field.
Note: If you enter an amount in the quantity and unit price fields, you must also fill out the Account field. If you don’t enter anything in any of these three accounts, you can still save and approve the bill with them empty.
After a bill has been issued and money paid against it, the From, Due Date, Reference, Branding Theme, Description, Account and Tracking fields are the only fields that you can still edit from within the bill.
Select from options in the drop-down menus in the available Tracking fields (if available).
Tracking is optional, and you won’t see the field if the feature is not set up. See Chapter 12 for guidance on setting up Tracking fields. The amount field can’t be edited. The subtotal, consumer tax and total automatically calculate. Populate the remaining rows with purchase information as needed. Note: In Figure 7-2 the Tracking field is called ‘Region’. Your Tracking field could be labelled something different.
Click the Add a New Line button (as required).
This allows you to add additional lines to the body of the bill. Once you’ve included multiple lines, they can be reordered by selecting, dragging and dropping as desired.
To on-charge the bill, click the Assign Expenses to a Customer link.
The Assign a Customer to Any Billable Expense window opens. You see three columns: Description, Amount (tax excl) and Customer. For each line of the bill, you have three options: Leave blank, select a customer, or select Decide Customer Later. If the latter is chosen, you will need to revisit and edit the Billable Expense to select a customer here. To confirm your selection, click the blue OK button. You can also come back and edit your customer selection, or add a customer later. If you’ve added multiple rows of expenses, each row can individually be assigned to different customers.
The billable expense details appear on the bill.
When a sale is raised to a customer tagged with the billable expense, the link Billable Expenses Can Be Added appears. Click the option you require to assign the expense lines.
Save the bill.
Xero gives you a number of options:
A lawyer I know spent a few weeks in bed recovering from a severe bout of pneumonia. As he lay there, with nothing to do but think, he mulled over his business performance. He wondered why the cash situation was so tight when he had been so busy. When he returned to work, he took a careful look at the books. The amiable bookkeeper, who regularly baked scrummy cakes for the office, had been siphoning off a considerable sum of money from the business. Combining a gambling habit with forged cheques and erasable ink sooner or later ends up with a visit to jail.
Any bank accounts through which cash leaves the business should be appropriately approved. In a micro or small business, approval of all payments may be the responsibility of the owner. In a larger business, different approval levels may be in place — for example:
The active word in the preceding examples is responsible. Approving payments should be treated with the utmost of importance and undertaken in a considered manner. Anything less may have a detrimental effect on cash flow. Within Xero, users who can approve a bill are those within the following user levels:
When approving a bill, you have a number of options:
Once a bill is approved it is filed in the Awaiting Payment area.
Here’s how to cancel, delete or void a bill, dependent on the status of the bill:
The details of a cancelled bill disappear entirely, while the erased details of deleted and voided bills can be found by searching under the grouping labelled All, clicking the Search button and checking the Include Deleted & Voided tick box.
While living in Cheltenham, I worked for an organisation that closely monitored promotional spends against budget. This process involved raising a detailed internal purchase order. The purchase order needed to be authorised by appropriate personnel, and my role involved checking the proposed account allocations.
A purchase order is a document detailing agreed spends for products or services. Internally, it monitors and controls spending; externally, it provides suppliers with authorisation to deliver their good and services.
The Purchase Orders dashboard is found below the Bills dashboard on the Purchases dashboard (found in Business → Purchase Orders). It’s quite sparse until you’ve created some purchase orders, but this section covers what it can include once it’s populated.
The high-level Purchase Orders dashboard is split into two blocks: Buttons and a menu bar. Click the blue See All hyperlink to see a detailed Purchase Orders dashboard. At the top is a button for creating new purchase orders and across the top are five tabs: All, Draft, Awaiting Approval, Approved and Billed (see Figure 7-3).
Clicking the + New Purchase Order button brings up the New Purchase Order form (see Figure 7-4). The steps for creating a new purchase order mirror the steps for creating a new bill — refer to the section ‘Creating a new bill’, earlier in this chapter. However, you need to be aware of the following three different options:
The block at the base of the purchase order includes fields for the Delivery Address, general contact details and Delivery Instructions.
The Delivery Address and Attention fields populate from the Organisation Settings existing information. To change the Delivery Address, click on the drop-down options and select from None, + Add New Address, + Add One-off Address, + Search from Contacts, Postal and Physical.
The Delivery Instructions field is a 500-character text field where you can include specific instructions for the delivery company — so, for example, you can let the delivery person know to bring your goods to the red door at the back of the building while navigating the guard dogs!
Like a bill, a purchase order can be saved or approved.
Although a little less exciting than cicadas emerging from underground after 17 years, understanding the life cycle of the purchase order is worthwhile. If you opted to save the purchase order as Draft, under the Draft tab, you have the option to Submit for Approval, Approve, Print, Send or Delete it.
Once a purchase order is Awaiting Approval, under the Awaiting Approval tab you have the option to Approve, Print, Send or Delete it (refer to Figure 7-3).
Under the Approved tab, you have the Billed, Print, Send or Copy To options. The Billed option marks the purchase order as billed, but does not create a bill from this. Once a purchase order has been marked as billed, under the Billed tab, you have the option to Print, Send or Copy the order.
You can use Xero several ways to record payments: Recording individual payments, preparing batch payments or linking payments against bills directly from within your Bank Reconciliation dashboard. The following sections take you through the first two options (turn to Chapter 8 for more on bank reconciliations).
To record a full or partial payment against a bill, follow these steps:
Go to the Purchases dashboard and click Business → Purchases Overview.
Bills need to be approved for payment before payment can be applied against them.
Select the bill to pay by drilling down through the Awaiting Payment tabs and click through to the detail of the bill.
The bottom of the bill features the Make a Payment block (see Figure 7-5).
Select the general ledger account the payment is to be made from using the drop-down list in the Paid From field.
Payment may be made from your bank, credit card or PayPal account, or any account set up to enable payments from this account (such as an intercompany loan account). Refer to Chapter 2 for guidance on customising general ledger accounts.
Enter a useful reference in the optional Reference field.
This reference won’t be picked up in search results, but it can be seen on some reports.
Check the box beside the Pay by Check (US) (or Cheque, in Canada) field (if required).
Only United States and Canadian users have this feature (see the sidebar ‘Payments made by check’ for more).
Click the green Add Payment button.
At the top of the screen, a green tick appears, along with confirmation details of the payment and a blue View Bill — Send Remittance Advice link. See the section ‘Sending remittance advice’, later in this chapter, for guidance on how to do this.
If the Pay by Check field was selected, the Pay by Check window opens.
The information on the check autofills, and the Check # and Pay To fields can be overridden. For traceability, adding further information to the optional Memo field is good practice.
Click the drop-down arrow at the Check Style field to select a check template style (if required).
See the section ‘Stylising your check’, later in this chapter, for information on different check styles.
Select your print and/or save options.
You have three options: Save & Print PDF, Save, and Cancel. To print a check, click Save & Print PDF and, at the Print Check window, click Print Now.
The PDF of the check downloads to your computer’s download file. To finalise payment, email or mail it to the client.
Recording batch payments may not be as enticing as a batch of warm and gooey chocolate-chip cookies, but using this feature within Xero can really reduce processing time.
To record batch payments, follow these steps:
Click the Batch Payment or Make Payment button (for US and Canadian users).
The Confirm window opens.
For US and Canadian users, the Make Payment window opens with three options: Pay By Check, Batch Payment and Pay with Bill.com (US only).
Click the green OK or Batch Payment button (for US and Canadian users).
The New Batch Payment window opens (see Figure 7-6).
Enter supplier bank account details in the Bank Account column.
Once a bank account has been allocated to a supplier payment, this account will save and be available the next time you make a batch payment. If you intend to use this process to transfer payments electronically, you must complete this field — see the next section.
Enter a payment or supplier reference in the optional Details fields.
Details added to the optional Details fields will appear on your bank statement.
If required, override the amount to be paid in the Payment column.
The amount outstanding for the bill autofills in the payment field; however, if you’re simply making a part-payment or deposit, override the amount.
Click the green Make Payments button.
The batch payment is created.
If you’ve never created a bank file, take a few moments to get your head around the process; it may save you a huge amount of time! A bank file is a file that can be uploaded to your internet banking. Payments are processed in Xero, and details of those payments (including full bank account details) are exported via a bank file. You then import the bank file into your online banking. But don’t worry — importing the file does not result in payments going out from your account like automatic balls from a baseball-pitching machine. Once the bank file is imported, you can see full details of pending payments and authorise them accordingly.
Note: Prior to being able to upload files to your bank, you need to contact your bank and let staff know you want to upload electronic bank files. Staff can then enable this feature. Depending on the bank, staff may need to provide you with a security code device and a direct entry user ID, and let you know if you need to include a self-balancing transaction.
After a payment is processed within Xero (refer to preceding sections), follow these steps to export a bank file:
Click Export Batch File from the batch payment window.
The bank file is downloaded to your computer.
Note: For this to work, business bank details and supplier bank details need to be entered into Xero.
Manually upload the file to your online internet banking.
Some financial institutions require you to use a banking security token at this stage. It generates a unique security code every few seconds. You need this code when you log in, along with your username and password.
After processing the bank file, you don’t need to store it, just delete it.
You may find you’ve assigned a payment to a bill and then need to remove it, because you need to change the details of the bill or the payment was allocated incorrectly. To ‘unallocate’ a payment, follow these steps:
Click on the relevant Less Payment hyperlink and the corresponding currency amount at the bottom of the column headed Amount.
The Payment transaction appears. If multiple payments have been assigned, multiple lines of payment will appear, and each one needs to be individually removed.
On the Payment transaction, click on the Options button, and select Remove & Redo from the drop-down menu.
The payment is removed from the bill. If additional payments need to be removed, click your web browser’s back arrow twice and then refresh the screen to see the current transaction details. Repeat Steps 3 and 4 to remove additional payments.
As well as the basic functions of entering and approving bills, and making payments, with Xero you can also master some more advanced options, such as working with repeating bills, scheduling payment and sending remittance advices. The following sections cover these aspects and more.
You’re unlikely to need to print the bill created in Xero on a regular basis, but if you ever need to, follow these steps to print your record of the supplier bills:
Go to the Purchases dashboard, drill down on the Awaiting Payment tab to find the relevant bill, and check the box to the left of the document(s).
A single bill or multiple bills can be selected and processed at the same time.
Click the blue Print button.
The Confirm window opens.
Click the green OK button.
The Print Bills window opens.
Click the green Print Now button.
You see a status window telling you that Xero is creating a PDF.
Unfortunately, many business bills arrive on an all-too-regular basis, but utilising Xero’s Repeating Bills function, which automatically generates new supplier bills based on a saved template, makes this a little less burdensome.
Once you’ve defined a Repeating Bill template, an automatic bill is created and saved as a draft or approved (as per the requirements you’ve defined within the template). Templates can be edited if terms change. All this results in you being able to use your valuable time to earn money rather than prepare bills!
To create a Repeating Bill, follow these steps:
Go to the Purchases dashboard, click on the drop-down menu beside the + New button, and select the Repeating Bill option.
The New Repeating Bill window opens (see Figure 7-7).
Fill out the Repeat this Transaction Every field.
You have a number of options here. For example, if you want the bill to repeat every month, enter 1 in the numeral field and select Month(s) from the drop-down menu.
Define the repeating Bill Due date.
Again, you have a number of options here. For example, if you want the bill to be due on the 7th of the following month, enter 7 in the Due field and select Of the Following Month from the drop-down menu.
Click the file symbol and attach files relevant to the recurring transactions.
If the recurring transaction was for car lease payments, for example, you could attach the original supporting lease document here, and it would be associated with every transaction — without using up any extra storage space.
Select the Save as Draft or Approve option.
Selecting this option tells Xero whether you’d like the bill saved as a draft or approved when it generates, based on the dates you have entered.
Where the bill is the same every repeat instance, you would choose the option to approve. Where the bill might vary in value every instance — for example, a phone bill — you would choose to save it as a draft.
Fill out the remainder of the body of the bill by following the steps outlined in the section ‘Creating a new bill’, earlier in this chapter.
Use the reference field to give the bill an identifying name.
Save the template by clicking the green Save button.
The template is filed under the Repeating tab. When the bill is created, it indicates that it has been generated from a repeating transaction.
A business I worked for in London struggled to pay its bills. Suppliers sat in the reception area throughout the working day, desperate to collect what was owed to them. The situation was very depressing. As money was made available, it was released and applied to outstanding bills. The members of the Accounts Payable department had to pay close attention to who was to be paid. Suppliers with goods and services that were needed to keep the business operating were prioritised. Future payments were grouped together in bundles of £10,000 lots, so the business could easily identify and pay critical payments quickly. Batching future payments enabled the business to protect its cash flow during difficult times.
While this wasn’t a happy scenario for the suppliers, the payment system kept the business afloat and people employed.
Xero’s Schedule Payments feature enables you to develop a program of planned payments, helping you manage your cash flow. You’re able to see the total payments due on a particular day, and you can click on the date to see a list of scheduled payments planned for that day. Follow these steps to schedule future payments:
Click the Schedule Payment button and select the intended date in the calendar box.
The Planned Date column fills out with the selected data. Hovering beside the planned date reveals a blue plus and minus option and a red cross. Clicking the blue plus and minus options increases or decreases the date by one day. The date can be overridden by clicking it and selecting another date from the calendar box or erased by clicking the red cross.
Once you’ve entered future payments, a Schedule of Planned Payments block appears on the Purchases dashboard, with the payments grouped by payment dates. Each block clearly details the date and the total group payment. Click on the block to drill down to see the batch payments for that date.
Note: Only US and Canadian users can access the Checks dashboard in Xero and customise a check.
To customise a check, follow these steps:
Go to Organisation menu → Settings → General Settings → Check Styles (under Features).
The Check Styles dashboard appears.
If you have an older version of Xero, you may have old-style checks set up. You can no longer create new old-style checks in Xero. While your existing old-style checks can be edited, new-style checks are easier to stylise and use, and upgrading is effortless. So I recommend ditching the old and embracing the new. On the top right corner of the old-style checks block, simply click the button labelled Upgrade to New Check Style to upgrade.
Click New Style on the top of the Check Styles dashboard.
The New Check Style editing window opens (see Figure 7-8). The Check design is in the top half of the window, and the Voucher design is underneath it.
The check doubles as a remittance advice, because it has room at the top for the check details and at the bottom is a voucher, with the reason for the payment. The recipient can give the check to the bank and retain the voucher for record-keeping purposes.
In the Style name field, enter Company Check.
See if the address details are correct and leave all the other information as is.
To ensure characters align with the pre-printed check stock, select the relevant Paper type, Paper layout, Font, Font size and move information fields to the appropriate areas.
Scroll down the screen to review the set-up for Vouchers.
Uncheck any information fields not required.
Upload a logo to the stylised check by clicking the Options button and selecting Upload Logo.
Note: The additional options that appear here are Edit, Copy, Upload/Change/Remove, Preview, and Delete.
Click Browse, select the logo, click Open and click the blue Upload button.
Magnetic Ink Character Recognition (MICR) encoding is supported, so you can print the routing number and account number on blank check stock and save money by not purchasing check stock for every account — though the ink is expensive!
A remittance advice notice lets your suppliers know that you’ve processed a payment against their bills, so they stop chasing you for payment! The notice details the supplier bills that payments have been applied against and can assist suppliers during their reconciliation process.
Send a remittance advice immediately after payment has been made by following these steps:
Click the Send Remittance Advice link or the Send Remittance button.
The Send Remittance Advice link appears at the top of the screen after making an individual payment and the Send Remittance button appears after making a batch payment.
Clicking the link or the button opens the Send Remittance Advice window.
If you need to resend a remittance advice, or didn’t send it directly after payment was made, access the Purchases dashboard and search for the relevant paid bill. Drill down to the detail, and click the blue Payment link on the bottom right (just above the Amount Due field). The Transaction: Payment window opens. At this stage you also have the option to View Remittance PDF, but it’s preferable to email it. Click Options → Send Remittance to access the Send Remittance Advice window. (This option isn’t available for US users.)
Fill out the Email Address field.
If the Contact already has an email address listed, it appears here. If an email address is entered as part of the remittance advice process, it is added to the contact’s details.
Select a remittance advice branded theme from the drop-down options for Use Branding Theme.
Refer to Chapter 6 for guidance on setting up branded themes.
Select an email template from the drop-down options for Email Template.
Refer to Chapter 6 for guidance on setting up email templates.
Check the Send Me a Copy box.
This allows you to maintain a digital copy of correspondence.
If a change to a supplier bill occurs, you may request the supplier issues a credit note. The credit note can offset outstanding bills, or accompany a refund. (If you have accounting knowledge, then, yes, technically this is known as a debit note — don’t get confused by Xero’s terminology!)
To process a credit note, follow these steps:
Complete the details on the Credit Note screen.
Include a reference to what bill it is applied against, and enter positive values!
Save or approve the Credit Note.
Follow the same steps as with saving and approving bills (refer to the section ‘Approving and cancelling bills’ earlier in this chapter, for more details).
If no outstanding supplier bill exists, the Approved Credit Note simply saves, and is listed on the Awaiting Payment grouping on the dashboard. If, at a future date, a bill is approved against the supplier, an Allocate Outstanding Credit? window opens, where you can select Allocate (or Skip if you don’t want to allocate now). Select Allocate and a window very similar to Figure 7-9 opens.
If, however, an outstanding supplier bill does exist, the Allocate Balance on Credit Note window automatically appears.
If the credit note should be applied to this bill, allocate the amount accordingly.
In the example shown in Figure 7-9, the value of the credit note can be split across individual bills or treated as a cash refund. Once you enter the full credit amount against a bill, the Remaining Credit balance becomes zero.
Where a new bill was raised against an existing credit note, you only have the option to allocate the credit note amount to the recently raised bill.
Click the green Allocate Credit button.
The amount is applied to the Bill. Note: The amount allocated cannot be greater than the invoice.
In an ideal world, you’re able to enter all business transactions through your business accounts and avoid cash transactions altogether; however, this rarely ends up being the case. Say, for example, an employee of your business fills the business car up with $50 worth of petrol and then pays for it personally — so spends personal money on behalf of the business. The employee charging the purchase to a company credit card, so it then goes through the normal payment process, is preferable, but in real life that may not be feasible. Instead, the employee needs to claim the money back from the business and the payment needs to be processed as an ad hoc expense claim.
Note: Xero allows two separate options for processing expense claims. The free (and original or ‘classic’) option is called Expense Claims, and how to use it is outlined in this section. Many advisers recommend their clients not to use the Expense Claims feature, because if you make an error, it can be almost impossible to correct. The new or modern option is called Xero Expenses, and an additional charge is incurred to access functionality. Organisations created after 10 July 2018 can only access the new Xero Expenses. For more on this new option, see the section ‘Understanding Xero Expenses Functionality’, later in this chapter.
Xero’s Expense Claims dashboard (accessed via the bottom right corner of the home dashboard) is where you process petty-cash type claims. All claims need to go through the same process. A new expense claim is first added as a Draft claim. It then needs to be submitted for approval, approved, and authorised for payment. Finally, the claim is paid and archived.
The Expense Claims summary dashboard (see Figure 7-10) contains four headings summarising the current status of expense claims, and an add New Receipt option.
Click through on the hyperlinks to drill down to the Expense Claims dashboard. Here’s a summary of the five headings on the Expense Claims dashboard (see Figure 7-11), and the information they provide:
The process of claiming an expense starts with the user entering the payment as a New Receipt in Xero.
To enter a New Receipt, do the following:
Scan your receipt.
You don’t need to be able to upload a copy of your receipt to Xero to process your claim, but storing receipts safely is always a good idea — rather than leaving them on the car dashboard to fade away! Xero allows .pdf, .jpg, .png and .gif digital formats for the scanned receipts.
Go to Classic Expenses from the dashboard, go to the Expense Claims box, click on the Expense Claims heading, and then click the Add Receipt button.
The Add Receipt window opens (see Figure 7-12). Multiple expenses can be entered and processed as a single batch at a later date.
Attach a scanned copy of the receipt to the transaction by clicking on the document icon.
The source document is stored online in a retrievable format. This is an efficient method of storing source documents and legal in many jurisdictions. Plus, the expense approval process may require it. Check your own local laws and requirements. This step is optional but it’s a good habit to adopt.
Enter the relevant receipt data and save the transaction.
In the Receipt From field, enter the supplier name. If you have more than one receipt to enter, select the blue Save & Add Another Receipt button, return to Step 1 and repeat the process. To record a single receipt (or once you’ve entered your last claim), click on the green Save button.
Saving your last claim takes you to an expanded view of the Current Claim window, listing a summary of current expense claims. Note: The status of the claim at this stage will be Draft, and the claim now needs to be approved (see the section ‘Submitting a claim for approval’, later in this chapter).
Keep on top of expenses while enjoying a latte by scanning and uploading expense receipts to Xero on your mobile device. (Now, to me, this sounds geektastic!)
Flatten your receipts and grab your mobile device — here’s how to upload the basics of an expense on your iPhone:
Tap on the Xero icon, enter your four-digit passcode or fingerprint and click the Receipts icon at the bottom of the screen.
A list of current receipts appears.
Click the + in the top right corner of the screen.
If you’re adding subsequent purchases after this, you’ll just need to click the grey cross on the top right.
A receipt entry form appears.
Enter the purchase description in the first line of the What Was It For? field.
The field draws from popular receipts — so, you may be able to select an existing reason, or enter your own.
Enter your name in the Where’d You Spend? field.
The field draws from your existing list of contacts, so you may be able to select an existing contact. However, in reality, expense claims can come from lots of little suppliers that you don’t want populating your Contacts list, so you may prefer to just add your own name here and add the supplier name at Step 3 (in the description field).
In the How Did You Pay? field, select I Want to Be Repaid.
This receipt entry is for an expense claim. At this field, select the business account it was paid from and record it as a Spend Money transaction. You can also add a Tracking code if you know it; otherwise, leave the Tracking code field blank. (However, I suspect many employees are in a better position to know what account the expense should actually be allocated to than the bookkeeper, so allowing them to code expenses could be another time saver.)
Click the grey Add Files button in the bottom right corner. Three options appear: Take Photo, Choose Photo or Choose from Xero Files. Choose Take Photo and take a photo of the receipt.
The image of the receipt attaches itself to the claim. In many jurisdictions, this is a legally acceptable storage method for paper receipts. (If unsure, check with your accountant.)
Click the optional details section to access three additional options:
Click the Add hyperlink on the top right of the screen.
And you’re done.
Here’s how to upload expenses on an Android device:
Tap on the Xero icon on your mobile device, and enter your four-digit passcode.
The home dashboard screen opens. Across the top are four headings: Dashboard, Invoices, Expenses and Contacts. Note: If you move away from the mobile version of Xero, when you return you need to re-enter your four-digit passcode.
Click on the Receipts heading at the top of the screen.
A list of current receipts appears.
Click the + on the top right corner of the screen.
A numbered Receipt screen opens. Refer to the section ‘Adding a new expense claim’, earlier in this chapter, for more. The fields available are What Was It For?, Where’d You Spend?, Date, How Did You Pay? and Categorise to an Account. Click the three dots (…) on the top right of the screen to add additional details: Split, Assign to a Customer, and Add a Reference.
As you’re entering the information, a comic image appears on the receipt to reflect the expense. For example, for a taxi charge, a man and dog in a yellow taxi appears!
On the middle right is a camera symbol to facilitate taking a photo or adding a file to the receipt.
Once the claim has been entered (refer to preceding sections), it needs to be submitted for approval, as follows:
Go to the Expense Claims dashboard and click on the Current Claim link.
This brings up the Current Claim table (see Figure 7-13).
Select the check box to the left of the expense claims that you want to submit for first-level approval and click the Submit for Approval button.
A confirmation box opens, informing you that you have selected items to be submitted for approval.
Click OK.
This moves the claim to the Awaiting Authorisation area in the Expense Claims window.
To view a summary of the claims awaiting authorisation, click on the Awaiting Authorisation link on the Expense Claims dashboard. Note: If you select multiple expenses for approval at the same time, they’re batched together in a single claim, so you only see one line here.
The claim still needs to be approved so the expense can be paid and included in the business financial statements — see the following section.
After an expense claim has been created and submitted for approval (refer to preceding sections), a first-level manager needs to authorise the claim.
To select the transaction that needs to be authorised, click the Awaiting Authorisation link on the Expense Claims dashboard. This takes you to the Awaiting Authorisation table (see Figure 7-14). Click through to the detail. Select the expense claim to be approved by clicking the check box to the left of the Receipt and click the Approve button. (I know this is a little bit confusing — this transaction was sitting under the Awaiting Authorisation link, so you probably would expect an Authorise button instead — but an Approve button it is!)
At the Awaiting Authorisation stage, you or the first-level manager who’s reviewing the claim can decline or delete the expense claim — if, for example, you decide it’s not an appropriate business expense.
Once the claim has been approved, it can be authorised by the second-level manager.
To authorise a claim, go to the bottom of the Expense Claims screen on the home dashboard and click on the Awaiting Authorisation link. Click though on a claim to see the underlying detail. Below this detail, the Authorise Expense Claim block appears with two fields to complete: Payment Due Date and Reporting Date (see Figure 7-15).
Complete the two fields and click the blue Authorise button, and claims are now ready for payment (covered in the following section).
Finally, you’re ready to pay the expense claim. Click on the Awaiting Payment link on the Expense Claims dashboard to view a list of expense claims awaiting payment. Click anywhere along the row to drill down to see the detail of the expense claim you wish to pay.
To complete the payment, you need to fill out the following four fields at the bottom of the Expense Claims window:
After completing the four fields, click the green Paid button. If opting to pay by check, the Pay by Check window appears. Refer to the earlier section ‘Recording an individual payment’ for details on how to fill out this window. The processed expense claim now sits in the archive summary area within Xero, and the claimant needs to be reimbursed for the claim, if that hasn’t already happened.
Xero Expenses offers a more streamlined process and increased functionality to the ‘classic’ Expenses functionality (refer to preceding sections), including simple data extraction via the mobile app, enhanced editing options, notification if an expense claim is rejected, the ability to limit the accounts that can be associated with an expense claim, and the ability to assign unique User labels so the individual users can track their own expenses. The new Xero Expenses is only available for an additional subscription fee, but if your business processes a lot of expense claims, paying the extra amount may be worthwhile. This section runs through how to process claims within the new Xero Expenses.
Note: If you have an older file and have activated the classic expense claims feature, you can still access the classic features, while using the new Xero Expenses. However, that could end up being confusing. Items entered through the classic expense claims feature, for example, will not flow through to the new Xero Expenses. I recommend only using either the classic expenses or the new Xero Expenses.
The Xero Expenses summary dashboard (see Figure 7-16) contains four headings summarising the status of expense claims, an Explorer area, a New Expenses option, and a Settings icon.
Here’s a summary of the four headings on the Expense Claims dashboard and the information they provide:
The Explorer area shows a vertical bar graph of expenditure, which can be displayed by user or account expensed. (This will only show information after an expense has been submitted.)
Click the Settings icon on the top right (it looks like a cog wheel), to access the Expense Settings dashboard, which opens at the General tab (see Figure 7-17). Tick the check box to enable receipt processing. When an image is uploaded via the Xero Expenses mobile app, some data is extracted and used to populate relevant fields. This minimises data entry; however, make sure you still review details for accuracy.
Click Users on the Expense Settings window to review and edit who can access Xero Expenses. Users need to be given specific access to Xero Expenses to submit claims. Three levels of access are available within Xero Expenses:
Click on Accounts to see which accounts have been selected to be available in the expense claims process. Typically, a business sets expense claims rules, governing what a staff member can claim back, so it may be expenses like petrol, parking and food, incurred while travelling. Therefore, to simplify the process, via this Accounts area in Xero Expenses, users can be only given access to restricted expense account codes.
Click on Labels to add, edit or delete labels, or view expenses associated with labels. Labels are unique to the individual, so you could monitor expenses incurred on a personal level, such as staff members’ expenses incurred while attending a conference.
The process of claiming an expense starts by entering the payment as a new expense in Xero.
To enter a new expense, do the following:
Go to the Expense Claims dashboard, go to Business → Expenses, and click the New Expense button.
The New Expense window opens (see Figure 7-18).
Drag and drop a scanned copy of the receipt to the Upload an Image area.
The details of the source document appear neatly on the left side, assisting in completing the expense information fields. Click the pencil icon in the bottom right corner to replace or remove the receipt, if it needs to be corrected.
Enter the relevant receipt data and save the transaction as a draft.
In the Spent By field, select the relevant User. The Supplier details can be entered in the Spent At field. If the expense needs to be split across multiple accounts, click the Itemise hyperlink, to add additional account lines. Splitting across multiple accounts cannot be done on the mobile app. Select the Save Draft option.
To record another receipt, return to Step 2, and click the New Expense button again.
Saving the last claim takes you to the Your Expenses area, within the Expenses dashboard.
Note: The status of the claim at this stage will be Draft, and the claim now needs to be approved (see the section ‘Submitting a claim for approval in Xero Expenses’, later in this chapter).
Embrace expense Zen and utilise those spare moments during the day by scanning and uploading expense receipts to Xero on your mobile device!
To start processing mobile expenses if you’re using Xero Expenses, you also need to download the Xero Expenses app from the Apple store.
Note: Four separate Xero apps are now available: the main Xero app (mentioned throughout this book), the Xero Expenses app (only for expense claims and what is covered in this section), the Xero Projects app (only for Projects and covered in Chapter 12) and the Xero Me app for Payroll.
Flatten your receipts and grab your mobile device — here’s how to upload the basics of an expense on your iPhone:
Tap on the Xero Expenses icon, initially enter your password and then your authentication code.
You are then given the option to, in future, enter your four-digit passcode or fingerprint.
Click the + in the centre bottom of the screen.
On the bottom left is a toggle button, which when turned on will try to auto-detect the receipt and take a photo. Capture and preview a photo of the receipt. If satisfied, select Use image.
Enter the purchase description in the first line of the What Was It For? field.
The field has space for 1000 characters. Select Save draft and the receipt is pushed across into processing. During the processing stage, data is extracted from the receipt and relevant expense fields populated, if permission was given for this to happen. Once processing has finished, click on the receipt again and check the fields are correct, including account allocation, and overwrite where relevant.
This receipt entry is for an expense claim. You can also add a Tracking code and Label if you know it; otherwise, leave the field blank. (However, I suspect many employees are in a better position to know what account the expense should be allocated to than the bookkeeper, so allowing them to code expenses could be another time saver.)
Select Save, in the top right corner.
Check the settings icon in the top left of the screen and click Logout to securely log out of Xero Expenses.
To start processing mobile expenses if already using Xero Expenses, download the Xero Expenses app from the Google Play store.
Here’s how to upload expenses on an Android device:
Tap on the Xero Expenses icon, initially enter your password and then your authentication code.
You are then given the option to, in future, enter your four-digit passcode or fingerprint.
Click the + in the bottom right of the screen.
The options Manual Entry, Photo Library and Take a Photo appear.
Enter the purchase description in the first line of the What Was It For? field.
The field has space for 1000 characters, so you have room to be descriptive. Once satisfied, click the arrow that looks like a paper dart on the top right corner to save a draft of the receipt. The receipt is then pushed across into processing. During the processing stage, some data is extracted from the receipt and used to populate relevant expense fields. Once processing has finished, click on the receipt again and check the fields are correct, including account allocation, and overwrite where relevant.
You can also add a Tracking code and Label if you know it; otherwise, leave the fields blank. (However, I suspect many employees are in a better position to know what account the expense should be allocated to than the bookkeeper, so allowing them to code expenses could be another time saver.)
Once the claim has been entered (refer to preceding sections), it needs to be submitted for approval, as follows:
Go to the Expense Claims dashboard and click on the Your Expenses tab.
This brings up any expense claim you’ve entered (see Figure 7-19).
Click on the draft expense claims that you want to submit for first-level approval and click the Submit button in the top right corner.
You have the opportunity to edit the claim before submitting.
Clicking Submit moves the claim to the To Review area in the Expense dashboard.
To view a summary of the claims awaiting authorisation, click on the To Review tab on the Expense dashboard.
The claim still needs to be approved so the expense can be paid and included in the business financial statements — see the following section.
After an expense claim has been created and submitted for approval (refer to preceding sections), a User with Approver or Admin Expenses access can authorise the claim.
To select the transaction that needs to be authorised, click the To Review tab on the Expense Claims dashboard. Summary details of expense claims awaiting approval can be seen here (see Figure 7-20). Click through to the detail. To approve an individual claim, click the Approve button to the right of the specific claim. To approve all claims, click Approve All at the top right of the list.
At the review stage, Users with Approver or Admin Expenses access can decline or delete the expense claim — if, for example, you decide it’s not an appropriate business expense.
Once the claim has been approved, it is ready to be paid.
When payments are approved, they are created as a bill awaiting payment in the Purchases area. They are slightly different to a typical bill, in that they cannot be edited and can only be voided.
Note: The From field is the name of the user who submitted the claim. If, say, the claim was for a named petrol station, no expense is associated specifically with that petrol station.
The Expense Claims bills can be paid individually or as a batch, as you would typical pay a bill.
3.143.214.230