Credit Card
Use the eDoc Credit Card form to import a transaction file from a bank and an image of the statement. Lines are matched to expense receipts and coded. Different lines in the file is read as credits, or can be ignored depending on the setup of the eDoc type.
You need to create an interface to match to the format of the bank transaction file.
On the eDocs Module Control form, the credit card should be setup with its own line so that eDocs knows how to process it.
The main statement image is the prefix at the start and the CSV or other file containing the transaction detail is entered in the Extra Info Extension column.
You can create multiple eDoc credit card transactions from one file import.
Credit cards are imported using the Import eDoc script. The top part of the credit card is populated with the lines read in from the bank file. Each line then needs to:
- Be coded as an eDoc. Double click the line or scroll to the right and type into the table
- Have a receipt allocated.
- Be coded for general ledger.
Both types of coding are the same as for an expense claim.
Match Receipt
As the lines on a credit card have already been added, instead of adding receipts you match receipts:
- Import from Email - Click this button to search for receipts that have been emailed from user email address set up in user preferences.
- Import from Folder - Click this button to import receipts from a folder.
- Auto Match - Click this button to automatically match the receipt to the credit card expense line. It matches based on Date and Amount.
- Match - If you select an expense line from the top credit card half and then select a receipt in the Unallocated tab, the Match button is enabled and assigns the selected receipt to the selected credit card line.