Importing and Merging Expenses With Bank Statements

Merge expense claims with the imported credit card statement from your bank.

Introduction

Import bank statements


Introduction

When a User has a business credit card to use for business expenses, they will put in an expense claim to cover their purchases on the credit card. When the credit card statement is imported, these expenses will be matched against the credit card statement by an administrator or approver.

  Return to Top of Page


Import bank statements

When the credit card statement or bank statement is received on internet banking, it can be imported so expenses can be matched to the statement.

The task would usually be performed by an administrator or approver.

  • Go to Expenses > Import.
  • Select the Expense Card.
  • Select the Import format
  • Browse or drag to select the file to bank statement file to import.
  • Click Import.

 

This process will merge the imported statement with the submitted expenses based on the card number, date and dollar amount of the expense.

Statement items are always in the transaction time and date order. That means if the User bought 2 coffees on the same day, and the date and the dollar amounts are the same for separate entries, the system will be able to merge the correct expense with the correct statement entry.

  Return to Top of Page


.

Was this helpful? If you require further assistance, or would like to contact us about this article, please email us at support@lentune.com.

Thank you. Your feedback is appreciated.

Last updated: 21 March 2022.