- Print
- DarkLight
- PDF
Is it possible to import a credit card statement into FIMS?
Article summary
Did you find this summary helpful?
Thank you for your feedback
Credit card statements usually require detailed and complicated AP voucher entries. Is it possible to import the statement into FIMS as an AP voucher?
Answer:
Yes you can import the statement into FIMS after some manipulation.
It is best to test this in the Test and Learn database first to be certain you are getting the results you want.
- Export or download the statement from your bank or provider. You will have to choose the correct format. You want a format that will open in excel. Usually most banks will offer a comma delimited or spreadsheet format.
- Open the exported data in excel and modify the lines or columns of data in the manner desired
Options:
- Each line can be a voucher line- add a column for the expense account.
- All expenses could be from one fund - use the import to identify the fundid.
- Expenses can be from different funds - use a column in the spreadsheet to identify the fundid.
- Modify the description or add a new column for the line item description
3. Once the spreadsheet is detailed in the manner desired, save as a CSV ( comma delimited) file.
4. Select File Maintenance > Accounts Payable > AP Voucher Import. Assign the particular values to their appropriate locations.
5. Be aware that most options have the following choices:
4. Select File Maintenance > Accounts Payable > AP Voucher Import. Assign the particular values to their appropriate locations.
5. Be aware that most options have the following choices:
- Select- to allow a single value to be used for all records imported
- Column # - to identify the column number if not in the list ( large spreadsheets)
- Column X - to identify which column in the spreadsheet holds the data
It is best to test this in the Test and Learn database first to be certain you are getting the results you want.
Was this article helpful?