1 minHow do I know if a new template is required?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...
2 minGeneral scanner tipsThe first and most important step is to convert your paper statements into an electronic format (TIF or PDF). This will be used as input...
1 minSingle condition summary using SUMIFSUMIF can be used to summarise many transactions for a single condition. Here are some examples: - Show the total credits where the date...
1 minMulti-condition summary using SUMPRODUCTSUMPRODUCT is a powerful formula that can be used to summarise transactions that satisfy many different conditions. Here are some...