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”.  Note, the  GL Account and Vendor Code must be manually entered into the import template.

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

 

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.