My First Workbook

If you are new to Home Credit Card Manager we suggest you try the exercises in the Sample Workbook before proceeding.

 

Overview

In summary, to set up your own workbook you need to:

  1. Create an account.
  2. Add a statement.
  3. Add one or more transactions.
  4. Assign categories to the transactions.
  5. Run the reports.

Note: You cannot add transactions until you have added at least one statement to an account.

Note: Most reports will be disabled until you have added at least one statement to an account.

 

Detailed Instructions

The major steps in setting up your own workbook are as follows:

  1. Create a new workbook (from the File menu choose New)
  2. Save the workbook (from the File menu choose Save As)
  3. Set up your credit card account details (double-click on the "New Account" entry)
  4. Add a new statement (click on the Add button on the toolbar in the Statement view screen)
  5. Import your transactions into Home Credit Card Manager if you have them in electronic format. For example, if you have downloaded them from your credit card provider's web site or you have them available in a spreadsheet (click on the Import Transactions button on the toolbar, or from the Action menu choose Import Transactions)
  6. Auto-Match the transactions in the statement (click on the Auto Match button on the toolbar, or from the Action menu choose Auto Match)
  7. Manually match the remainder of the transactions. Note that each month there will be less transactions for you to manually match, as the Auto-Matching tool uses previous statements to allocate categories automatically.
  8. As you manually match categories, look out for common or repeating words in transaction descriptions that could be used as category wildcards. For each suitable word or phrase add a Category Wildcard (from Category menu choose Maintain Categories). Refer to Category Auto-Matching for more information on category wildcards.
  9. Run the Yearly Totals Report.
  10. Run the Yearly Comparison Report.
  11. Run the Statement Comparison Report.