1. Help Center
  2. Accounting
  3. Assistant Accountant/Department Head

How to: Import Credit Card Charges

Use Import Storage to enter and post your credit card charges

Step 1: Download your credit card transactions into an excel format from the respective credit card website.  

Step 2: Under Accounting, click IMPORT STORAGE.

 

Step 3: Click DOWNLOAD TEMPLATE.

 

Step 4: Begin copying and pasting all the transaction detail from your credit card transactions excel sheet onto the “csv import template”.  

2021-05-09 18_57_39-Template (12).csv - Excel

Note: The  GL Account and Vendor Code must be included in the import template.

 

Step 5: Click UPLOAD CSV.

 

Step 6: Click UPLOAD and choose the template from where it is saved on your computer.

 

Step 7: Click SUBMIT.

Step 8: Click the + to the right of Journal Entries on the left navigation.

2021-05-09 18_21_50-Dashboard

Step 9: Select the vendor from the drop down menu.

2021-05-09 19_15_18-Journal Entry

Step 10: Select the transactions in the Add Imports window then click ADD.

2021-05-09 19_21_38-Journal Entry

Step 11: Fill in all required fields in the Summary section.

2021-05-09 19_28_07-Template (12).csv - Excel

Step 12: Enter the account for the credit card liability in the credit line that is created automatically. 

2021-05-09 19_24_09-Journal Entry

Step 13: Add notes and upload files as needed.

2021-05-09 19_29_11-Journal Entry

Step 14: Click SUBMIT.

Note: The transaction follows the journal entry approval workflow, which you may always customize with our Project Setup Team, upon onboarding.