WELCOME TO GMS ACCOUNTING ONLINE HELP
The help you need at your fingertips.
#413 CC/ACH Import
|
Function Import Credit Card statement to create a voucher and the corresponding CD batch.
Export the credit card statement as an Excel file. Save the file in a designated folder. Modify the file so it contains the Vendor Number, Date of transaction, Description & Amount.
Export the credit card statement as an Excel file. Save the file in a designated folder. Modify the file so it contains the Vendor Number, Date of transaction, Description & Amount.
Operating Instructions
Example of Excel file to be imported:
Example of Excel file to be imported:
A. Select the GL code for the credit side of the file to be imported. GMS recommends this as a liability code. The CC Import is intended to record the charges made on the credit card.
B. Enter the alpha code of the column that corresponds to the fields. In the example file above, the description is in column A, the Amount is in column G, etc.
Note: To find the vendor from the CC statement, there are 2 options. Modify the file to create a column with the vendor code or if you want to find the vendor by name, the exact vendor name from the vendor file would need to be entered. Make sure to select “Match vendor by vendor name” is checked.
C. An optional field. Select an element if the entire CC import will be charged to just 1 element.
D. Once all the fields have an answer, click on Process/Reprocess File. The file will be processed and appear in the grid.
B. Enter the alpha code of the column that corresponds to the fields. In the example file above, the description is in column A, the Amount is in column G, etc.
Note: To find the vendor from the CC statement, there are 2 options. Modify the file to create a column with the vendor code or if you want to find the vendor by name, the exact vendor name from the vendor file would need to be entered. Make sure to select “Match vendor by vendor name” is checked.
C. An optional field. Select an element if the entire CC import will be charged to just 1 element.
D. Once all the fields have an answer, click on Process/Reprocess File. The file will be processed and appear in the grid.
The Element column will be blank or filled in with the element number selected above. The GL column will need to be entered. In the vendor file, if there is a GL Code in the GL code field, this code will appear
If the answers in section B are wrong or you need to modify the file, exit out of voucher import, make the changes in the file to be imported and go back in. Make the selections at the top again and click on Process/Reprocess File. A message will appear stating the file has been processed before do you wish to reprocess. Answering Yes will clear the grid and populate it with the changes you made.
Print the report when the grid is complete and accurate. An excel file will be opened and have the same information from the grid. You MUST Click on File and then Save. GMS will save it in a folder automatically so there is no need to try and save it like a normal Excel file.
Return to the CC Import screen and now the Import button will be available. Click on Import. A message will appear stating the folder and name GMS has used. Click on Yes to proceed.
If the file has been imported successfully, the below message will appear:
If the answers in section B are wrong or you need to modify the file, exit out of voucher import, make the changes in the file to be imported and go back in. Make the selections at the top again and click on Process/Reprocess File. A message will appear stating the file has been processed before do you wish to reprocess. Answering Yes will clear the grid and populate it with the changes you made.
Print the report when the grid is complete and accurate. An excel file will be opened and have the same information from the grid. You MUST Click on File and then Save. GMS will save it in a folder automatically so there is no need to try and save it like a normal Excel file.
Return to the CC Import screen and now the Import button will be available. Click on Import. A message will appear stating the folder and name GMS has used. Click on Yes to proceed.
If the file has been imported successfully, the below message will appear:
Clicking on OK will close out of the CC Import screen and open up the Check Register. The report title is "Other Payments". The Record# is an internal number only needed if this payment needs to be voided.
