If you are familiar with making adjustments to your clients' living expenses directly in Excel, you can still do so with the v2 report, but there are a couple of rules that you will need to know about first.

There are a couple of rules that apply to the version 2 report. These make it much faster to make adjustments.

The Summary Categories tab of your report contains 3 columns of information that control which Category (green) and Summary Category (blue) any transaction can belong to.

The Category Type (red) controls which summary the category belongs to. There are only 2 options, the Expense Summary (HEM-related) or the Other Outgoings Summary.

Example

A transaction categorised as a Gambling expense is automatically included in the Recreation & Entertainment Summary Category which is automatically included in the Expense Summary (HEM-related).

The mapping shown in the Summary Categories tab above matches the mapping contained in the Category Mappings tab, of your CashDeck account.

From the All Transactions tab, simply find any transactions that you want to remove and change the Category (column H) to Unreported.

This moves them to the Other Outgoings Summary of your report.

Example. Let's pretend that the highlighted Uber and Cabcharge payments below were work-related and not personal expenses.

Type Unreported into the Category (column H).

Those transactions are moved to the Other Outgoings Summary automatically.

From the All Transactions tab, simply find any transactions that you want to remove and change the category (column H) to the category you need them to belong to.

This will automatically add these transactions to the correct Summary Category (column I), and move them to the appropriate summary of your report.

Example. Let's pretend that the highlighted Kmart transactions below, were specifically clothing expenses.

Changing the Category (column H) to Clothing (as shown below), automatically adds those transactions to the Summary Category Clothing and Personal Care.

Those transactions are now included in the correct summary automatically, in this case, the Expense Summary (HEM-related).

Step 1.

Copy all of the totals in the summary.

Step 2.

Paste those totals in the next column over, or anywhere you like.

Moving those numbers outside of the pivot table allows step 3 to work.

Step 3.

Select the cell to the right of your first total.

Click the equals (=) key.

Click on the first total to the left i.e. $2,257 in the example below.

Then divide (/) that by the number of months in your report.

Our reports tend to cover whole periods i.e. 1,2,3,6 or 12 months. Note, that the first and last months presented in the summaries of your report are normally part months.

i.e. in the example below.

The blue section covers 5 complete months.

The green section represents part months, not whole months.

The red totals cover 6 months.

You can also view the number of days retrieved inside your client's completed request.

Prefer to see how it works? Take a look at the video's below.

Watch a recorded training session below or read on for step-by-step instructions.

Watch the video below to find out the quickest way to calculate the average amount per category per month, in Excel.

The video below shows you how to move transactions from one category to another.

The video below shows you how to remove transactions from the Expense Summary (HEM-related), and move them to the Other Outgoings Summary by marking them as 'Unreported'.

Watch the video below for extra examples.