How to Import Expenses from a csv file

To save more hours in your day, you can now import expenses from a CSV file.

You may import expenses you have been charged by a supplier who is not a Prism finance subscriber*, or import expenses from a text file you have generated to save manual input.

If your supplier is also a Prism Finance subscriber, we recommend the Import invoices from a supplier feature.

From the Finance page, click + Add Expense then select ‘’ Import Invoice’’ option

The Import Expense dialog displays.

1. To import expenses, you must have the expenses recorded in a defined file format and structure.

2. You can download a template file from the dialog by clicking on the Download Template file link.

3. Copy or add expenses into the template, and optionally save as a different filename.

4. Import the file by clicking Browse button to select the file and then click the Import  button.

5. All expenses will be displayed in the next window before saving.

6. Update the Supplier to be applied for all expenses in this window

7. Split / Edit / Delete expenses as required

8. Optionally import more expenses by clicking Import more button to select another file

9. Click Save button to import the expenses.

Each expense will be displayed in Finance > Transactions, ready for invoicing via the month-end Statement Run or the Single Invoice feature.

• Related Articles

• How to import invoices from a supplier who is using Prism

  Prism Finance subscribers can import invoices received from any supplier who is also a Prism Finance subscriber. This feature is ideal for trainers and syndicators who receive invoices from any other training, pre-training/breaking, veterinary, ...

• How to configure import of invoices from a supplier who is using Prism

  Prism Finance subscribers can import invoices received from any supplier who is also a Prism Finance subscriber. This feature is ideal for trainers and syndicators who receive invoices from any other training, pre-training/breaking, veterinary, ...

• How to view Expenses by Horse

  You are able to view the expenses created / charged for each horse during a time range, in the Horse Expense screen. Navigate to Horse Profile > Expense tab Apply a filter for the time range you would like to view.

• How to manually add Group Expenses

  When you have a bill with multiple line items, you can add them quickly to Prism by using the Add Group Expense function. From the Finance page, click + Add Expense then select “Group Expense” option, the Add Group Expense dialog displays. Supplier: ...

• How to Manage Transactions in Finance

  One of the major tasks of the Finance module is to capture all expenses during a billing period, either automatically or manually, ready for review and invoicing during an end of period Statement run. There are various types of transactions recorded ...