Knowledge base

When you see data appearing in the wrong columns, a new template is required. Data appearing in the wrong columns means that there is a...

The first and most important step is to convert your paper statements into an electronic format (TIF or PDF). This will be used as input...

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

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

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