How to Import a Credit Card Statement
Before you can import a credit card statement, it is essential to have added a credit card holder in the system. Adding a credit card holder enables you to set up and map payees as suppliers.
Prerequisite
- Add a Credit Card Holder: Ensure that a credit card holder is set up in the system before importing a credit card statement.
Steps to Import a Credit Card Statement:
-
Navigate to Manage > Credit Cards.
-
Select "Excel" on the Manage Credit Card Screen.
- This will open the Excel Pop-Up page.
-
Click on "Download Template" on the Excel Pop-Up page.
- This action will start the download of a pre-formatted Excel template necessary for importing credit card statements.
-
Locate and open the downloaded template file on your device.
-
Complete the required information marked in red on the template.
- Optionally, you can fill out the entire template to import all desired information.
- Optionally, you can fill out the entire template to import all desired information.
-
Save the filled template file locally on your computer.
-
Navigate back to Manage > Credit Cards.
-
Again select "Excel" on the Manage Credit Card Screen.
- This will bring up the Excel Pop-Up page.
-
Click on "Import" on the Excel Pop-Up page.
-
Click "Select File" and locate your Credit Card Import file.