Administration
      Back to home
      1. Knowledge Base
      2. Expense Claims
      3. Administration

      Import Bank & Credit Card Statements for Expenses

      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 a user who manages the expense approvals.

      Import bank statements

      When the credit card statement or bank statement file is received on internet banking, it can be imported so that the expenses that the user has entered into the system can be matched to the statement.

      The task would usually be performed by a user who manages the expenses approvals.

      • Go to Expenses and click the Import button on the left menu bar. You can also run the Import from the Unsubmitted menu option.
      • Select the Expense Card and the Import format that you want.
      • Browse or drag to select the bank statement file to import and 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.

       

      import expenses- 11426-1

       

      The slider bar at the foot of the dialog box will show you the progress of the import. If there is any problem with the file, you can click on the link to download to see what has happened. This might occur if you selected an incorrect format to import.

      When the import has completed successfully, you will see a message at the foot of the dialog box: Import has completed. Download to see the contents. If you wish you can click to open the new file of the imported data. 

      The details on the statement will be imported and merged with the expenses. Now the administrator can proceed to approve the expenses.

       

      TIP: Statement items are always in the transaction time and date order. Therefore if someone purchases two of the same items on the same day, and the date and the dollar amounts are the same for the separate entries, the system will be able to merge the correct expense with the correct statement entry.

      Need more help? We’re here! We hope our article was helpful! If you need more info or want to connect, drop us an email at support@lentune.com.

      Thank you. We love to hear from you!

      Last updated: 23 November 2023