Tax tricks: Join multiple CSV files, remove duplicate lines, and a spreadsheet trick to very quickly sort business transactions by keywords you choose.

Trick for sorting your business expenses using a spreadsheet, quickly Here is a quick summary of what will be covered in this article, useful for people that own their own small business but do not want to buy specialized financial software:  downloading CSV files of your transactions for bank accounts and credit cards, and how to batch concatenate (join) multiples of them together all at once, how to remove duplicate lines, and finally how using a spreadsheet you can quickly use keywords of your own to sort all of your expenses into categories like meals, entertainment, hotel and travel expenses.  This is not only useful for small businesses but good if you like to keep track of your personal expenses as well.   Continue reading “Tax tricks: Join multiple CSV files, remove duplicate lines, and a spreadsheet trick to very quickly sort business transactions by keywords you choose.”