Knowledge base

1 min read

How can I compare the numbers within the transaction narrative with the credit or debit amount?

You can use one of Excel's text formatting formulas to identify whether the credit or debit matches the numbers in the transaction...

1 min read

How can I strip out the recipient from the transaction narrative?

Some text manipulation can be used to cut out the sections of the narrative that interest you. This formula looks for 'from' or 'to' and...

1 min read

Is there a quick way to write a lengthy IF statement?

When Excel reads a statement that returns TRUE or FALSE, these values are interpreted by the formula as 1 or 0, respectively. Therefore,...

1 min read

What is a CSV file?

CSV (Comma Separated Values) is a file format that is widely accepted when importing data into a variety of different applications. It...

1 min read

What are absolute and relative formulae?

When you copy and paste formulae that reference other cells within a spreadsheet, the cell references are automatically interpreted as...

1 min read

How can I quickly categorise bank transactions using Excel?

Data validation can be used to create a drop down box showing categories that can be easily allocated to individual transactions. This...

1 min read

Is there an easy way to find company data?

If you need to search UK company data by directors, shareholders or financial performance then you should use www.duedil.com. The user...

1 min read

How can I search Companies House data for many companies?

If you have a list of many company names (perhaps creditors or debtors) and you need to check which ones are dissolved or subject to...

1 min read

Balance checks using SUM

Balance checks are used to validate that the data exported from bank statements is correct. They are quick and easy to apply, although...

1 min read

Single condition summary using SUMIF

SUMIF can be used to summarise many transactions for a single condition. Here are some examples: - Show the total credits where the date...

1 min read

Multi-condition summary using SUMPRODUCT

SUMPRODUCT is a powerful formula that can be used to summarise transactions that satisfy many different conditions. Here are some...

1 min read

Date adjustments using DATE

Changing dates across many lines of transactions can be tiresome. To ensure that this process is fast and accurate, you should use the...