Manage Credit Card Statements

The Manage Credit Card Statements page lets you create and edit credit card statement periods for reconciling your credit cards.

Credit Card Reconciliation Grid

Existing statements display in the grid with the following columns:

• Statement Date
• Ending Balance
• Note: Hover over the Note icon to preview the note.
• Setup: Hover over the Information icon to display user and time information for when the statement was set up and last updated.

To work with statements in the grid:

1. Double-click an existing statement or click the Edit icon to edit it.
2. Click the Add New Statement link to add a new statement.

Reconcile Credit Card Statement

In the Reconcile Details window, enter the Statement Date and Ending Balance. Click OK to begin reconciling, or click the Close link to return to the Reconciliation page.

Note: When adding the first statement date for a credit card, you must also specify the Starting Balance.

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

Reconciliation Tab

Charges are on the left, and Payments/Credits are on the right. Both sections display the following columns:

• Amount
• Date
• Vendor

Note: Charges on this page were entered through Enter Credit Card Transactions or Manage Unposted Credit Card Transactions. Payments on this page are the result of creating, saving, and paying a credit card payment invoice through the reconciliation process, or selecting to apply a created payment invoice for a credit card vendor toward the credit card and then paying that invoice.

On the left, the Statement Date and Statement Ending Balance display the 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 displays along with the Net Charged/Credits and Calculated Ending Balance.

Note: The active report area at the bottom of the page tracks your progress as you mark transactions as cleared. After you have marked all cleared transactions, the Difference field should show zero. The Statement Starting Balance and Calculated Ending Balance fields should match the amounts shown on your current credit card statement.

To mark transactions as cleared, select items in the Charges and Payments/Credits sections. You can also import cleared items from a file.

To import cleared items:

1. Click the Import Credit Card Statement link.
2. Click Choose File and select your import file. The program accepts the.OFX,.QIF,.QFX and Excel formats.
3. Click Import to display the Credit Card Reconciliation Statement Import Report. This report displays all items in the imported file, along with whether they were imported.
4. Click Close Report to return to the Credit Card Reconciliation page. All items in the imported file that match (ItemDate and Amount) are marked as cleared.

Note: If importing an Excel file, it can have any name but must be saved in the .xlsx format and contain these columns: Date (or ItemDate), Description (optional), and Amount.

To view the Reconciliation Report:

1. Click View Reconciliation Report to display a preview. The report has two sections: Current Summary and Cleared Items. The Current Summary displays the Opening Balance, Payments/Credits, Charges, and Ending Balance. The Cleared Items section displays Item #, Date, Description, and Amount for each cleared item.
2. Navigate the pages, export to several formats (PDF, Excel, Word), or click Print. Click Close Report 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 lets you attach files from your device or scan image files using the Scanner.Client.exe program. See the Attachments Help Page for detailed information about the attachments feature.

Credit Card Payment

To save, finalize, or discard your reconciliation:

• Finish: Finalizes the statement period and opens the Credit Card Reconciliation Payment window.
• Apply and Finish Later: Saves your progress and returns to the Reconciliation page without finalizing.
• Reset: Undoes all changes since the page was last updated.
• Cancel: Discards all changes and returns to the Reconciliation page.

Important: If the Statement Ending Balance and Calculated Ending Balance fields do not match, you are prompted that the statement is not in balance. Click OK to continue finalizing, or click the Cancel link to return to the Update page and make corrections.

In the Credit Card Reconciliation Payment window, you have the option to set up a payment to the selected credit card for all or part of the statement ending balance.

1. Select one of the following payment options:
   • Schedule Invoice to Pay: 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: Records e-Payments, e-Checks, PayPal payments, or 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: 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: Does not create a transaction.
2. Enter the appropriate information in the fields, then click OK to finish the reconciliation, or click the Cancel link to return to the Update page without finalizing.

Tip: If your ending balance is zero, normally select Make No Payment Now.

Updated May 21, 2026 01:46