Credit Card GL accounts must be setup before importing bank statements.
For each of the credit cards you wish to use with this SuiteApp, one Credit Card Configuration record must be created.
When you are able to download a file that contains transactions for multiple NetSuite GL accounts, you can setup a Multiple Statement Configuration record.
Setup a Credit Card Configuration Record
A Credit Card Configuration must be created for each of the credit cards (NetSuite GL Accounts).
For the following step you must have the Show Internal IDs preference enabled. If this preference is not enabled, go to Home > Set Preferences. Under General tab, Default section, mark Show Internal IDs. Click Save.
When you have multiple credit cards in your company but post them all in one NetSuite GL account, only one configuration record is necessary.
CSV Configuration: This records tells Fast Four Credit Card how to interpret the csv file that you will import.
- Go to Setup > Credit Card Import > Credit Card Configuration > New
- Inactive and Credit Card Configuration fields: leave blank
- GL Account: select the GL account
- Multi-Statement: If a Multi-statement record was created (see the next step) and it should be connected to this config record, select it here
- Multi-Statement Identifier: if a Multi-Statement record was selected, enter the value in the Card Column from the import file (step 5 of Multi-Statement configuration above). The card column in the statement file might for example show XXXX-XXXX-XXXX-X123, then the value in this field should be XXXX-XXXX-XXXX-X123.
- Currency: The currency of the card should have been auto-populated after selecting a credit card account
- Subsidiary: If you do not use NetSuite OneWorld, just select Parent Company.
- Folder ID: Enter the ID created in the Create Folder step
- Date Column: enter the number of the CSV-column that contains the reference to the date (Column A=1, column B=2, etc)
- Amount column: enter the number of the CSV-column that contains the amount (Column A=1, column B=2, etc)
- Description Column: enter the number of the CSV-column that contains a description (Column A=1, column B=2, etc)
- Currency Column: leave blank
Charge/Credit Column: if the .csv file contains a column that indicates whether something is a charge or credit, enter the number of the column. If the file uses separate columns for charges and credits,
- enter the Charge column in the Charge/Credit column field and
- enter the Credit column in the Amount column field
- Charge/Credit Identifier: select the value that is applicable to the import file
- Date format: select the date format
- CSV delimiter: select the CSV delimiter used in the import file (most often this will be , (comma))
- Transaction type to create: select Credit Card unless you have a specific reason to choose otherwise
- Default Vendor: on a Credit Card transaction, a vendor is mandatory. You may select a vendor on line level on the credit card statement when processing the transactions. However, you may opt to choose a default vendor here, that will be used when you do not select a vendor on the statement. Many customers choose a 'generic vendor' or 'Miscellaneous vendor' here. If you create vendors every time there is a credit card transaction with a new vendor, this is not applicable.
- Number of header rows: enter the number of headers rows in the import file. Note: if you use a Multi-Statement import, the value here should be 0.
- Number of trailing rows: enter the number of trailing rows in the import file. Note: if you use a Multi-Statement import, the value here should be 0.
- Comma as decimal separator: if the file contains amounts with a comma as decimal separator, check this box.
- Auto-match vendor bills: Checking this box will trigger an auto-matching to open vendor bills based on document number. Be careful for false matches.
- Use tax: check if you wish to calculate tax on credit card transactions
- Default VAT code: only select if you want to use a default tax code. This is only recommended if you should calculate tax on every credit card transaction
- Defaults: Class, Department, Location - select if applicable
- Show reconciliation alerts: leave this box checked unless you have a specific use case
Please note that the most left column of a CSV file is column 1