Skip to main content

Worksheets

After setting up your WhereMoneyGo account your spreadsheet will have a number of new worksheets added to it. Here's a description of what each does

Transactions​

This is your main transaction sheet. We'll automatically add new transactions to the top of this sheet as we receive them from the bank.

If we receive any updates, such as better categories or a final amount charged, we'll automatically update the rows without touching any data you've added or changed yourself.

The Date, Amount, Category and Acount columns are self descriptive. If you want to change the Acount name for future transactions you can do so on the Acounts worksheet.

The Amortize column sets up the transaction amortization, as described in the amortization documentation.

The Status column will be Pending if the bank has not yet confirmed final details of the payment. If we detect a refund we'll mark the status of one of the transactions as Refund and the other as Refunded. We'll also set the amortization of the refund to the original transaction date so that they cancel eachother out.

The Transaction ID and Acount ID columns are used by WhereMoneyGo to make sure we track your transactions correctly. You shouldn't need to change them.

Day Summaries​

Here you'll find all of your transactions summarised by day. To make it easier to see where the transactions come from, each day value is actually a formula adding up all the original values.

Month by Category​

This spreadsheet shows you your spending every month, split up by all the primary categories. You can see how the numbers are calculated by looking at the formula of each cell.

For example =31*(N("ANNUAL MEMBERSHIP FEE")+100/365) shows a transaction ANNUAL MEMBERSHIP FEE which was for $100 but amortized over a year (365 days). In the current month you had 31 charges of that fee.

Amortize​

This spreadsheet sets up categories for amortization.

Categories​

This sheet lists all the Categories in use by your Transactions. From here you can set certain categories (such as Inter-account Transfers) to be ignored in your daily and monthly summaries.

Match Rules​

This worksheet allows you to automatically configure certain transactions. For example you can set your monthly healthcare payment to amortize over a month, and the category to Healthcare (if we don't already get it right.)

A full description on how to use this spreadsheet is available in the matching documentation.

WhereMoneyGo​

This spreadsheet is used internally be the WhereMoneyGo tool. The cursors keep track of what transaction update was last loaded into your sheet. If you remove them we'll start fetching all your transactions again from the beginning.