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

 

 

Related Topics

 

 

 

 

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.

 

infoSource 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.

 

infoWhen 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