Import expenses

Modified on Wed, 25 Oct, 2023 at 5:13 PM

Biztory is able to create multiple expenses at the same time using the import feature. Kindly follow the steps below to import the expenses.

1) Click My Biztory on the right top


  • Click the 3rd Party App to view the features and ensure the CSV Import is ticked. 
  • Click Expenses tab
  • Click Download Expense Sample CSV to view the required data need to prepare 
  • Click Upload CSV then select the Expense sample CSV

3) Preview the data, click Import button then expenses will be prepare to import.

4) Sample expected result after imported 

Data definitions 

  1. ref_num - Expense invoice number
  2. invoice_date - Date of the invoice
  3. gst_supply_date - GST supply date (Key in invoice_date if don't have GST supply date)
  4. payee - Supplier name
  5. total - Total of invoice (Sum all of the items)
  6. amount - Amount of item
  7. price - Price of item (Same as Amount)
  8. code - Item code (Act as Category) (Remark: our system needs exactly the name for the expense category and is sensitive to lower case and upper case e.g Charges > charges)
  9. description - Description of item.

Important noted

  1. The user is encouraged to import sample CSV in order to understand the flow of the import feature.
  2. The column header is fixed and required related data which same as the sample expense CSV
  3. The import will take effect after a few minutes, kindly refresh the Expense page after the import. In addition, the user may try to re-import again if the expenses does not create automatically.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article