 | Source files can be obtained from First Data or American Express as a part of your merchant services. Contact your merchant provider for more information regarding this service. |
Reconcile Credit Card Deposits |
Previous Top Next |
Menu Navigation
Activities ... Banking ... Reconcile Credit Card Deposits
About Topic
When reconciling your bank account, you may find several deposits from your credit card merchant, each of which contain one or more credit card payments combined together. While recording the deposit, you would need to add up various payments to see if they add to a deposit amount found on your bank statement. This can provie to be a tedious task, especially if you have a large number of credit card payments or if some payments approved on the same day are not deposited on the same day. To alleviate this, ManageMore can match up all of the payments for you using the payment records in the software and an import file available from your merchant account provider. The program will automatically create a bank deposit that will be easily found and verified during your bank account reconciliation.
This feature requires activation in Setup Banking. Please note that this feature may not be included in your software license.
In this Topic
Quick Help - Reconcile Credit Card Deposits
Field by Field Help - Reconcile Credit Card Deposits screens
Q & A - Reconcile Credit Card Deposits
Related Topics
13.1 Bank Accounts
13.2 Payment Methods
14.1 Chart of Accounts
14.6 Reconciliations
Quick Help - Reconcile Credit Card Deposits
| 1) | Select the Reconcile Credit Card Deposits menu option. |
| 2) | Select the File Source, then click Next. |
| 3) | Select the file or files to import, or change which directory files are being searched for by clicking on Change Folder. Then click Next. |
| 4) | If any unmatched records show up, select them and the ManageMore payment records to which they should be matched. Click on the Match button to manually match these records up. Continue until all records from your file have been matched. Then click Next. |
| 5) | Select the Bank Account, Deposit Date, and enter the Document ID for this credit card deposit. Enter the GL Account to be affected if there is a difference in the amount being imported and the amount matched. Then click Finish. |
Field by Field Help - Reconcile Credit Card Deposits screens
Welcome to the Wizard
File Source
Select the type of source files you will be matching records from. Select from First Data or AMEX.
| Source files can be obtained from First Data or American Express as a part of your merchant services. Contact your merchant provider for more information regarding this service. |
| When downloading a file, make sure that you give the file an extension of ".CSV" and that the files all go into the the same folder. This folder will default to the My Documents folder on your local machine (or your My Documents folder on the server if you are using Terminal Services). |
Select File(s) to Import
Folder
Displays the folder where ManageMore is looking for downloaded credit card deposit files.
Change Folder
Click this button to change the folder where ManageMore will be searching for downloaded files.
Refresh
Click this button to have ManageMore re-read and display the contents of the selected folder.
File Name
Lists the files found in the folder selected. Name of the files will be shown along with checkboxes on the left side of the name. To include a file, double click on the checkbox to the left of that file.
Date Modified
Shows the date that the last changes were made to this file.
Size
Shows the amount of disk space this file uses.
Match Payments for Deposit
This screen will only be visible if one or more of the payments in the selected import files were not found in your ManageMore company data.
Unmatched Records
Displays the date, time, last 4 digits of the credit card number, and amount of the unmatched import payments.
Pending Payments for Deposit
Displays the receipt number, payment description, date last 4 digits of the credit card number, and the amount of payments that have not been deposited or matched up yet.
Sort Lists by
Click in this field to select the manner in which both lists should be ordered.
Match
Click this button to match the selected record(s) on the left with the selected record(s) on the right. To select a record on the left, simply click on it. To select a record on the right, double click on the checkbox accompanying the payment record. You can also match two or more records on the right side (for example a positive and negative amount that add to zero) to remove them from the current view. Once records are matched, they will be removed from the screen.
Unmatch All
Click this button to unmatch any matches already made in this file.
Clear Selection
Click this button to clear any selections on the screen so that all currently displayed records are left unselected.
Reset
Click this button to reset all matches and re-read the file into ManageMore.
Total Selected
Displays the total amount currently selected on the adjacent list of records.
Total Unmatched
Displays the total amount of the payments unmatched on the left side (import side).
Total Matched
Displays the total amount of the payments matched so far.
Total Deposit per Import
Displays the sum of payments from the import file.
Total Difference
Displays the difference in the Total Matched and the Total Deposit per Import. Ideally this amount should be zero, or as close to zero as possible.
Finish Credit Card Deposit
Bank Account
Select the bank account where the credit card deposit was made.
Deposit Date
Enter or select the date on which the deposit was made.
Document Id
Enter the document id number associated to this deposit, if applicable.
Total Payments Marked for Deposit
Displays the total amount of the ManageMore payment records that have been marked in this process.
Total Difference
Displays the difference between the amount of payments marked and the amount of payments found in the imported file.
GL Account
Enter or select the GL account number where the difference amount should be posted. This field will only appear if the Total Difference field is something besides 0.00.
Total Deposit per Imported File(s)
Displays the total amount of the imported file(s) as selected in the second step.
Q & A - Reconcile Credit Card Deposits
| Q01. | I don't see my question here. Where else can I get information? |
| A01. | Visit our website's Technical Support section. |
 |
|
| © 2015 - Intellisoft Solutions, Inc. All rights reserved. | |
| Other Related Links | |
| Business Software | Cellular Software | Pager Software | Business Management Software |