...
Before creating the new setup, download your credit card statement in the standard format
In Workbook: finance & administration module> Export export, Import import & Maintenance maintenance sub-menu> personal expense credit card
Go to the import file tab > and click the ‘import’ button
...
The data import box will open
Click on the settings tab > the create import specification button
...
Complete the following fields:
...
Once you’ve set up the above fields > go back to the execute tab > and select your newly created specification from the dropdown
...
Now you’re ready to set up the fields to match your credit card statement
When entering the fields some of them will require formatting. See notes below
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Above fields in blue - these fields wouldn’t commonly be available on a credit card statement but you can add them prior to import if you wish, just make sure the values match Workbook WorkBook exactly. |
Field 1 needs to match column A in your bank statement, Field 2 matches column B etc.
...
If a field needs a format selected it will come up with a yellow triangle
...
Click on formatting > and enter a value from the dropdown box to match your bank statement export E.g. dates: dd/mm/yyyy or numbers: -1,234.56/1,234.56
Now that you’ve setup the specification, you can import your credit card file and check that the information matches correctly
EXAMPLE
...
ADDITIONAL FORMATTING OPTIONS - SCRIPTS
Scripts are used when additional formatting is required on an import. You can use them to delete extra lines at the bottom of the import or calculate 2 fields.
In the bank reconciliation data import go to the settings tab > select the add new script parameter button
Complete the fields in the add data import script pop up (see script examples below) > click ok
...
Standard script usage:
CalcFields
...
Credit card statement:
...
Script:
...
Fields:
...
Related articles
| Filter by label (Content by label) | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...