Illustrated tutorials
How to categorise transactions in Excel using DropToExcel

Step 1 – From the checkboxes provided, select the areas that you would like to summarise for your transactions. For example, select ‘categories’.

Step 2 – Select ‘data structure’ on the left of the DropToExcel window. Using the dropdown boxes and your Excel input file containing transactions, identify the Excel columns that the required data is in. For example, dates may be in column A – so select A next to ‘date’, and so on. The transaction sheet number relates to the sheet containing the transactions in the input Excel file – change this from 1, if necessary.

Step 3 – Select the column you would like to use to create or that contains the categories. If you select ‘source’ the selected column will be analysed using the keywords specified. If you select ‘result’ then the selected column will be used as the category column. Note, if you select result, step 5 isn’t required.

Step 4 – Select ‘categories’ on the left of the DropToExcel window. Enter the name of the category you would like to add, for example ‘cash’. Click ‘add category’.

Step 5 – Select the newly added category and enter some keywords that can be used to identify this category. Multiple words can be separated by a comma, for example ‘cash, atm’.

Step 6 – Select ‘create separate tab’ if you would like transactions for the selected category to be copied to a separate tab in the output Excel document.

Step 7 – Click ‘save and close’.

Step 8 – Drag and drop your input Excel file on to the DropToExcel icon. Alternatively, select ‘new summary’ from the File menu of DropToExcel.

Step 9 – The results will be displayed in Excel.
How to identify duplicate transactions in Excel using DropToExcel

Step 1 – From the checkboxes provided, select the areas that you are interested in summarising for your transactions. For example, select ‘duplicates/unique trans.’.

Step 2 – Select ‘data structure’ on the left of the DropToExcel window. Using the dropdown boxes and your Excel input file containing transactions, identify the Excel columns that the required data is in. For example, dates may be in column A – so select A next to ‘date’, and so on. The transaction sheet number relates to the sheet containing the transactions in the input Excel file – change this from 1, if necessary.

Step 3 – Select ‘duplicate/unique trans.’ on the left of the DropToExcel window. From the checkboxes provided, select the columns that you would like to use to compare transactions. For example, if you select ‘date’, ‘description’ and ‘amount’, transactions with the same date (see step 4), description and amount will be copied to a separate tab in the output Excel document.

Step 4 – Enter the acceptable distance (variance) in days between transactions for comparison purposes.

Step 5 – Click ‘save and close’.

Step 6 – Drag and drop your input Excel file on to the DropToExcel icon. Alternatively, select ‘new summary’ from the File menu of DropToExcel.

Step 7 – The results will be displayed in Excel.