Import Receipts

Import Receipts creates sales receipts from a CSV file collected from your bank. It is anticipated that if you use this feature, you will import receipts on a regular basis, not just when you receive a monthly bank statement. Imported receipts can then be allocated automatically if you choose.

Before using Import Receipts:

• Set up your company bank account in Company Set-up > Bank Details.
• Define the import format according to the CSV file format your bank uses.
• Create bank account details for your customers on the Trader card.

  Note: There is an option to create bank accounts as the file is imported, if you don't want to create customer bank account details first.

There is a hierarchy used to allocate payment type and nominal.

• If the trader has a Payment type set up, that is used.
• Next, the payment type and associated nominal set in Bank Import Configuration are used.
• If the payment method hasn't been added to the bank in Company Set-up > Bank Details (right hand pane), Horizon reverts to using the nominal specified for your bank account, set under the left-hand pane.

Importing Sales Receipts

1. On the Sales menu, click Ledger.
2. From the toolbar, click Import Receipts. The Banking Import Batch Management window opens on the Batches tab.

   Note: If you have not set up an import, you are notified.

3. In the Bank list, select your company bank account, from which the file of transactions originates.
4. Click Rules. The Banking Import Rules window opens. There are two types of rules you can create:
   • Always ignore this trader
   • Always match this trader when description contains.

   Existing rules are listed below. Click Close when you have created your rules.

5. Click Add batch.
6. Click Select file. Browse to the CSV file obtained from your bank, select it, and click Open (or double-click the file).
7. In the Date box, today's date is already selected. Type a new date or pick from the calendar if required. This is the date of the batch, often the date on the bank statement.
8. In the Description box, type a description to identify the batch. This will often be something to identify part of your bank statement.,
9. When Automatically allocate is selected, the rules you have defined will be used to match and allocate the newly created sales receipts to sales invoices.

   Note: If the option in Define Import, Default import to automatically allocate is selected, the Automatically allocate option will be selected when you open the Add Batch window.

10. Click Load file. Batch imported successfully is displayed when complete. Click OK.
11. The imported batch is added to the list:
    • Date – date chosen in step 7.
    • Description – from step 8.
    • Batch Status
      • Processing – displayed if the system gets stuck while processing
      • Imported – batch successfully imported
      • Completed – batch has been set as Completed in Modify Batch Header.
12. You can now manage the imported batch, by modifying the batch header or the batch details.
13. Show completed batches can be selected to show batches set as Completed. When cleared, completed batches are hidden.
14. Click Close.

See Also