Credit Card Statement Reconciliation > Update

The Credit Card Reconciliation > Update page allows you to reconcile your credit card transactions for the selected statement period. There are three tabs: Reconciliation, Notes, and Attachments.

This Section Includes:

ØReconciliation Tab

ØNotes Tab

ØAttachments Tab

ØCredit Card Reconciliation Payment

Reconciliation Tab

Charges are on the left and Payments/Credits are on the right.

 

 

For both sections the following columns are displayed:

•Amount

•Date

•Vendor

On the left Statement Date and Statement Ending Balance display information you entered when creating or updating the selected statement period. The Difference is the amount between the calculated Statement Ending Balance and the entered Statement Ending Balance.

On the right the calculated Statement Starting Balance is displayed along with the Net Charged/Credits and Calculated Ending Balance.

 

 

Select items in the Charges and Payments/Credits sections to mark them as having cleared. You can also choose to import cleared items by clicking the Import Credit Card Statement link. Click the Choose File button and select your import file. The program accepts the .OFX, .QIF, .QFX, and Excel formats. Click the Import button to display the Credit Card Reconciliation Statement Import Report. This report displays all items in the imported file and whether they were imported. Click the Close Report button to return to the Credit Card Reconciliation page. All items that match (ItemDate and Amount) in the imported file are marked as cleared.

 

 

Click the View Reconciliation Report button to display a preview of the report. There are two sections to the report: Current Summary and Cleared Items. The Current Summary displays the Opening Balance, Payments/Credits, Charges, and Ending Balance. The Cleared Items section displays the following information for each cleared item: Item#, Date, Description, and Amount.  Once the preview displays you can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click the Close Report button when finished to return to the Reconciliation Update page.

Notes Tab

Enter a note in the field provided if you wish.

Attachments Tab

The Attachments tab allows you to attach files accessible from your device or to scan image files using the Scanner.Client.exe program. See the Attachments Help Page for detailed information regarding the attachments feature.

 

Credit Card Reconciliation Payment

 

Click the Finish button to finalize the statement period, the Apply and Finish Later button to save your progress and return to the Reconciliation page without finalizing, the Reset link to undo all changes since the last time the page was updated, or the Cancel link to discard all changes and return to the Reconciliation page.

 

 

The Finish button displays the Credit Card Reconciliation Payment window. You have the option for setting up a payment to the selected credit card for all or part of the statement ending balance.

Select an option from the following:

•Schedule Invoice to Pay: This option creates an invoice using the date in the Due Date field and the amount in the Payment Amount field and places it in Manage Unposted Transactions.

•Electronic Funds Transfer: Electronic Funds Transfers allow you to record e-Payments, e-Checks, PayPal payments, or any other online bill payments. When this option is selected, the Check Date field changes to Payment Date, and the Confirmation # field becomes available.

•Create a Manual Check: This option creates a manual check transaction using the information in the Check Number, Check Date, and Payment Amount fields and places it in Manage Unposted Transactions.

•Make No Payment Now: This option does not create a transaction.

 

 

After making your selection and entering the appropriate information in the fields click the OK button to finish the reconciliation process or the Cancel link to return to the Update page without finalizing the reconciliation.