Читать книгу Xero For Dummies - Heather Smith - Страница 85

Once Xero is set up, you will receive payments against outstanding sales invoices, so they need to be in the system to reconcile against when the money is receipted. Note: Xero groups the invoices you issue under the Sales area (see Chapter 6 for more details).

In the lead-up to a conversion, I encourage clients to chase all outstanding sales, pay what bills they can, and review any potential bad debts. This assists with detoxing the data and minimises transactional data being brought across into Xero.

Australian and New Zealand users have the option of importing MYOB Service and Item Sales invoices, exported directly from MYOB.

Follow these steps to import sales details into Xero:

1 From Xero’s Dashboard go to Business → Invoices and click the Import button.The Import Your Sales Invoices window opens.

2 Click the Browse button to select the required file.For example, you could select the SalesImport.csv file from the DataReadyForImporting folder in the CONVERSION folder.Before you import your sales details, you need to answer two questions about the file. Select Yes or No to ‘Would you like to update contact address details?’, and define whether the UnitAmount field is Tax Exclusive or Tax Inclusive.Clicking the Import button displays a report on the impending import process in the Import Your Sales Invoices window.

3 Review the report integrity.The import action can’t be undone if you proceed, though once imported the draft invoices can be bulk deleted if you make a mistake. If further editing of the data is required, click the grey Go Back button and review the imported data file.

4 Once satisfied, click the green Complete Import button to import the data.The imported sales are imported in Draft status and now display in Xero. You have the opportunity to enter additional data in each invoice, and approve them as outstanding. (See Chapter 6 for information on dealing with draft invoices.)

5 Enter credit notes.Credit notes or negative sales can be imported in the same way. See Chapter 6 for information on entering credit notes.

6 Manually update any imported records where the consumer tax wasn’t the standard rate.Find the relevant imported invoices, click on them and update their details to reflect the correct allocation of consumer tax. See Chapter 6 for information on editing sales invoices.

7 Correct any issues by sorting out individual issues or deleting and re-importing the data.The imported invoices only have a single line of transactional details. You can import multiple line items on a single invoice by using the same invoice number for each line item. Xero will group lines with the same invoice number into one invoice with multiple item lines. If you still need to add additional detail, such as a different Due Date or additional transactional information, locate the invoice, click on it to edit it, and save it.To delete a draft invoice you don’t need, click the check box to the left of it and click the red Delete button. You can delete draft invoices in bulk by selecting multiple invoices before clicking the red Delete button.See Chapter 6 for more information on locating and editing sales invoices.

8 Check the import balance matches the balances of the data imported.

9 Approve sales invoices individually or as a batch.See Chapter 6 for details on approving sales invoices.