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.
Most banks these days allow you to download your transaction history. If you’re like me, I use a credit card for most of my transactions and get a cash back reward. 99% of my transactions are by credit card, and some transactions by debit. I download the .CSV files every few months and when tax time comes around I use these CSV files for the primary sorting of my business expenses. Instead of using paper receipts, I use my memory and the transaction descriptions in the credit card or debit CSV files I downloaded. Some banks only maintain 3 months of transactions for you to download, some banks 6, 9, 12, 18 or unlimited months of transactions. Be sure to have a reminder set up so you don’t forget to download the CSV files! This will save you a lot of time come tax time so you won’t need to be going through your paper statements and typing out numbers manually.
How to batch join multiple CSV files using a Windows PC
It’s quite simple really. Put all of your CSV files for your credit card into a single folder. CSV files are very simply comma or tab delimited text files with line breaks after each row. You just need to make it into a big text file first and let the computer do this for you to save time. If you’re familiar with DOS batch files, simply create a batch file in that folder with the following command:
copy *.csv all.csv
This will take all .csv files in the folder and make a single file called “all.csv” that you can open with a spreadsheet application such as Excel or OpenOffice.org (which is free and I highly recommend as a Microsoft Office alternative). If you do not know how DOS batch files work, just download my batch file here and unzip it into the folder with all your CSV files. Double click on the batch file (.bat file) and it will run on Windows 7 for example, or any other copy of Windows.
How to remove duplicate lines from a large CSV file for free with TextPad
For Windows there is a program I use called TextPad. It is a fantastic simple text editor. Open your concatenated large CSV file with TextPad and from the Tools menu choose “Sort”. In the Sort dialog, at the bottom there is a checkbox called “Delete duplicate lines”. Be sure to check this and all the duplicate lines will be deleted and a bonus you are sorting the CSV file too. Save the file and open the saved file now with your spreadsheet application as a comma or tab delimited CSV file.
How to use a spreadsheet to quickly sort your expenses into categories of your choosing
I have created a spreadsheet template for you already and you can download it here. Below I provide you with graphical instructions on how to use the spreadsheet. Click the image for a larger version.
I have included a button in the spreadsheet that is presently configured to launch a Macro function that will look for keywords you choose out of column “C” and delete any rows containing those keywords. For example, this is useful to delete rows that you do not want in the spreadsheet such as rows containing transactions of you paying off a credit card, or other transactions like email money transfers, or transactions between accounts. If using Excel, you will need to adjust your security settings so that it will enable the macro to run.
You can expand the spreadsheet to contain any number of transactions, simply select a bunch of rows by highlighting a bunch of rows using the row numbers along the left and then right-click on the row numbers you selected and select from the popup menu “Insert rows”. The more rows you select the more it will insert, you can repeat this a few times until you have thousands of rows.
Be sure to “Fill down” and “Fill across” so that the sorting equations in the main body of the spreadsheet are there so that you don’t miss any tabulations. Each cell has a formula and the logic of each formula is this: if the keyword you typed in the left column matches the column heading keyword, then this cell is equal to the transaction amount going out. If this cell is not equal, leave cell blank.
I have included a column on the far right hand side with conditional formatting in orange that warns you when a row does not contain a sorted value, you can use this to see when you’ve made a typo on the keywording for example. Sum totals are at the bottom of the spreadsheet.
I use a sheet similar to this every year for my taxes and I am able to sort about 1000 transactions per year in this way, in about 1 hour. This is a huge time savings because sorting 1000 transactions with paper would take perhaps days of my free time.
Happy taxes!
You have some Duplicate Files on your computer which hampers your memory space.
Just use “DuplicateFilesDeleter”.If you use this software you will be get comfortable.
Duplicate file are really disturbing. Just use “DuplicateFilesDeleter program”
Sometimes we get an error when we try to delete a File or a folder for no reason , but of course there is a reason.We have many damage file or blocked files.Do not worry if we want to remove the error files or too long path files from our system,here I suggest a smooth way.So use “Long path tool” software and keep yourself.
Sometimes we get an error when we try to delete a File or a folder for no reason , but of course there is a reason.We have many damage file or blocked files.Do not worry if we want to remove the error files or too long path files from our system,here I suggest a smooth way.So use “Long path tool” software and keep yourself
Amazing all kinds of useful material!
http://canadianpharmacysilo.com/
buy online prescription drugs
canadian pharmacies that ship to us
trust pharmacy canada
[url=http://canadianpharmaciescubarx.com//]canada pharmaceutical online ordering[/url]
Great forum posts. Appreciate it!
http://canadianpharmacymim.com/
mexican pharmacy online medications aarp approved canadian online pharmacies legitimate canadian mail order pharmacies [url=http://canadianonlinepharmacynnm.com/]canadian pharmacies online[/url]
best online pharmacies canada
canadian pharmacy without prescription
canadian pharma companies
pharmacy tech
canada pharmacies without script
online pharmacy without prescription
Very good facts. Regards!
http://canadianpharmaciescubarx.com/
trusted overseas pharmacies london drugs canada drugs for sale [url=https://nicktambone.com/]canadian pharmacies-24h[/url]
canadian discount pharmacy
online pharmacy no prescription needed
canadian online pharmacy reviews
drug costs
costco pharmacy pricing
the canadian pharmacy
Truly a lot of good info.
http://canadianpharmacysilo.com/
canadian drugs canada online pharmacies buying drugs canada [url=http://canadianpharmacysilo.com/]online pharmacies canada[/url]
canada online pharmacy
online pharmacy canada
top rated online canadian pharmacies
best online pharmacy
pharmacy online mexico
canadian cialis
Regards! Helpful stuff!
http://talahicc.com/
internet pharmacy trust pharmacy canada canadian pharmacy 365 [url=https://nicktambone.com/]canadian pharmacy online[/url]
pharmacy prices
walgreens pharmacy
canadian online pharmacy
prescription drugs canada
<a href="http://jesserubenfeld.net/?s=You+actually+said+this+wonderfully%21+http%3A%2F%2Fcanadianpharmacysilo.com%2F+drug+stores+near+me+canadian+pharmacy+online+canada+drug+pharmacy+%5Burl%3Dhttp%3A%2F%2Fcanadianpharmacyntx.com%2F%5Dcanadian+pharcharmy%5B%2Furl%5D+%0D%0Acanadian+pharmacy+%0D%0Aprescription+drugs+canada+%0D%0Acanadian+pharmacy+online+canada+%0D%0Aonline+pharmacy+usa+%0D%0Ainternational+pharmacy+%0D%0Aprescription+cost&s=You+actually+said+this+wonderfully%21+%0D%0Ahttp%3A%2F%2Fcanadianpharmacysilo.com%2F+%0D%0Adrug+stores+near+me+canadian+pharmacy+online+canada+drug+pharmacy+%5Burl%3Dhttp%3A%2F%2Fcanadianpharmacyntx.com%2F%5Dcanadian+pharcharmy%5B%2Furl%5D+%0D%0Acanadian+pharmacy+%0D%0Aprescription+drugs+canada+%0D%0Acanadian+pharmacy+online+canada+%0D%0Aonline+pharmacy+usa+%0D%0Ainternational+pharmacy+%0D%0Aprescription+cost”>canadian pharmacy viagra brand
online pharmacy
Nicely put, Many thanks!
http://canadianpharmacysilo.com/
canadian pharmacy viagra canadian online pharmacies top rated online canadian pharmacies [url=https://nicktambone.com/]online pharmacies canada[/url]
online canadian pharmacy
no prescription online pharmacy
online prescription drugs
no prescription pharmacies
prescription cost
pharmacies in canada
Valuable info. Kudos.
http://www.canadianpharmacymsn.com/
canada pharmacies prescription drugs canada pharmaceutical online ordering pharmacy drug store [url=https://nicktambone.com/]canadian pharmacies[/url]
get prescription online
meds online
king pharmacy
safeway pharmacy
buy drugs online
cheap prescription drugs
Thanks. I like it!
http://canadianpharmacymim.com/
canada drugs online canada drugs online canada pharmacies prescription drugs [url=https://nicktambone.com/]top rated canadian pharmacies online[/url]
drugs without prescription
drug costs
buying prescription drugs canada
canada pharmacies online prescriptions
compare rx prices
canadapharmacy
Regards! I appreciate it.
http://canadianpharmacymim.com/
canadian pharmacy without prescription top rated canadian pharmacies online safe canadian online pharmacies [url=http://canadianonlinepharmacynnm.com/]aarp approved canadian online pharmacies[/url]
canada pharmacies online prescriptions
pharmacy without dr prescriptions
trust pharmacy canada
trust pharmacy canada
mail order pharmacies
canadian online pharmacy reviews
Thanks a lot. Ample material.
http://canadianpharmacysilo.com/
northwestpharmacy mexican pharmacies shipping to usa canadian prescriptions [url=http://canadianpharmaciesnnm.com/]northwestpharmacy[/url]
canadian cialis
canadian pharmacy
most reliable canadian pharmacies
visit poster’s website
buying prescription drugs canada
international pharmacies that ship to the usa
Incredible many of valuable data.
http://canadianpharmaciesnnm.com/
prescription drugs without prior prescription canada pharmaceuticals online online pharmacy without prescription [url=https://nicktambone.com/]canadian pharmacies online[/url]
canada pharmacy online no script
global pharmacy canada
online canadian pharmacies
reputable canadian mail order pharmacies
cialis online
<a href="http://jesserubenfeld.net/?s=+With+thanks%2C+Valuable+information%21+http%3A%2F%2Fcanadianpharmaciescubarx.com%2F+canadian+pharmacies+top+best+canada+pharmacy+online+canada+online+pharmacies+%5Burl%3Dhttp%3A%2F%2Fcanadianpharmacysilo.com%2F%5Donline+pharmacies+of+canada%5B%2Furl%5D+%0D%0Abest+online+pharmacy+%0D%0Acanadian+prescription+%0D%0Acanadian+rx+%0D%0Amexican+pharmacy+online+medications+%0D%0Acompare+prescription+prices+%0D%0Adiscount+pharmaceuticals&s=+%0D%0AWith+thanks%2C+Valuable+information%21+%0D%0Ahttp%3A%2F%2Fcanadianpharmaciescubarx.com%2F+%0D%0Acanadian+pharmacies+top+best+canada+pharmacy+online+canada+online+pharmacies+%5Burl%3Dhttp%3A%2F%2Fcanadianpharmacysilo.com%2F%5Donline+pharmacies+of+canada%5B%2Furl%5D+%0D%0Abest+online+pharmacy+%0D%0Acanadian+prescription+%0D%0Acanadian+rx+%0D%0Amexican+pharmacy+online+medications+%0D%0Acompare+prescription+prices+%0D%0Adiscount+pharmaceuticals”>discount drugs online pharmacy
Good material. With thanks!
http://canadianpharmacymim.com/
best online canadian pharcharmy canadian online pharmacies rx online [url=http://canadianonlinepharmacynnm.com/]canadian pharmacies-24h[/url]
walmart pharmacy price check
online drugs
online pharmacy no prescription needed
mexican pharmacies
cialis canadian pharmacy
compare rx prices
With thanks! Quite a lot of postings!
http://canadianpharmacyntx.com/
pharmacies near me canadian pharmacies online discount prescription drugs online [url=https://nicktambone.com/]canadian pharmaceuticals online[/url]
online pharmacy
online pharmacies canada
canadian meds
canadian drugstore reviews
canadian pharmacy no prescription
prescription cost
Wow lots of amazing information!
http://talahicc.com/
pharmacies near me online pharmacies of canada canadian pharmacy viagra brand [url=http://canadianpharmaciesnnm.com/]canadian drugs[/url]
canadian pharmacies that ship to us
drugs for sale
safe canadian online pharmacies
rx pharmacy
canada pharmacies online prescriptions
online pharmacies no prescription
Whoa a good deal of awesome info!
http://canadianpharmaciesnnm.com/
global pharmacy canada global pharmacy canada online rx pharmacy [url=http://canadianpharmaciescubarx.com/]online pharmacies canada[/url]
pharmacy near me
canadadrugs
canadian pharmacy 365
internet pharmacy
pharmacy tech
pharmacy prices compare
Amazing tons of awesome knowledge!
http://www.canadianpharmacymsn.com/
prescription cost global pharmacy canada prescription drug [url=http://www.canadianpharmacymsn.com/]canadian pharmacies that ship to us[/url]
drug costs
best online canadian pharcharmy
canadian meds
costco pharmacy pricing
no prescription pharmacy
ed meds online
Nicely put, Kudos.
https://nicktambone.com/
ed meds online london drugs canada canadian drugstore online [url=http://talahicc.com/]canadian viagra[/url]
canadian pharmacies shipping to usa
canadadrugs
canada drug prices
canadian pharcharmy online
canadian pharmacy reviews
cheap canadian drugs
Thanks. Useful stuff.
http://canadianpharmaciesnnm.com/
canadian online pharmacies prescription drugs mexican pharmacies shipping to usa buy prescription drugs online [url=http://canadianpharmacyntx.com/]northwestpharmacy[/url]
northwest pharmacy canada
pharmacy canada
mexican pharmacy online medications
canadadrugs.com pharmacy
mexican online pharmacies
international pharmacies that ship to the usa
Kudos. Excellent stuff.
https://nicktambone.com/
prescription cost comparison canadian viagra canadapharmacyonline com [url=https://nicktambone.com/]canada online pharmacies[/url]
mail order pharmacy
compare prescription prices
online pharmacy
trusted overseas pharmacies
northwestpharmacy
canadian drugstore
Great facts. Regards.
http://canadianonlinepharmacynnm.com/
canadian prescription northwestpharmacy top rated canadian pharmacies online [url=http://canadianpharmacysilo.com/]canada pharmacy online[/url]
the canadian pharmacy
canadian online pharmacies
approved canadian pharmacies online
canadianpharmacy
discount prescription drug
cheap prescription drugs online
You have made the point!
http://canadianpharmacysilo.com/
pharmacy prescription north west pharmacy canada prescription drug price comparison [url=http://www.canadianpharmacymsn.com/]canada online pharmacies[/url]
best price prescription drugs
canada pharmacies
canadian drug
web medical information
mexican pharmacies
canada drugs online
Nicely put. Many thanks.
https://nicktambone.com/
pharmacy canada canadian cialis canadian drugstore online [url=http://canadianpharmacysilo.com/]trust pharmacy canada[/url]
canadian pharmacies without prescriptions
canadapharmacyonline com
pharmacy drug store
legitimate canadian mail order pharmacies
canada online pharmacy
canadian rx pharmacy online
This is nicely expressed. !
http://talahicc.com/
online pharmacies canadian pharmacies canadian mail order pharmacies [url=http://canadianonlinepharmacynnm.com/]canadian pharmacies that ship to us[/url]
best non prescription online pharmacies
get prescription online
pharmacies in canada
online canadian pharmacies
drug costs
pharmacies near me
Amazing all kinds of useful info!
https://nicktambone.com/
canadian viagra canada drugs online canadian viagra [url=http://canadianpharmacysilo.com/]canadianpharmacy[/url]
canada pharmacies
online canadian pharcharmy
prescription cost
prescription without a doctor’s prescription
pharmacy price compare
best online international pharmacies
Wow loads of helpful material.
http://canadianpharmacyntx.com/
canada drugs online pharmacy canadian drugs online pharmacies [url=http://canadianonlinepharmacynnm.com/]canadian pharmacy[/url]
canadadrugs.com pharmacy
best online pharmacy
canadian pharmacies online
best online pharmacy stores
canadian drugstore online
canadian rx
Awesome write ups. With thanks!
http://canadianpharmacyntx.com/
candrugstore com canadian pharmacy mail order pharmacy [url=http://canadianpharmacysilo.com/]canada drug[/url]
internet pharmacy
mexican online pharmacies
buy drugs online
canadian online pharmacies
buy prescription drugs from canada
prescription drugs without prior prescription
Incredible a lot of superb information!
http://talahicc.com/
internet pharmacy canada drugs web medical information [url=http://canadianpharmacyntx.com/]canadian pharmacy online[/url]
online drugs
pharmacy online
canadian drug store
reputable canadian mail order pharmacies
mexican pharmacies online
canadian pharcharmy online
Reliable data. Thanks a lot.
http://canadianpharmacymim.com/
canadian online pharmacies prescription drugs canadian pharcharmy best canadian pharmacies [url=http://canadianpharmaciescubarx.com/]canadian drugs[/url]
costco pharmacy pricing
mexican pharmacies
buying drugs canada
drug prices comparison
canadian viagra
online prescription drugs
With thanks! Plenty of posts.
http://canadianpharmacymim.com/
canada meds mexican pharmacies shipping to usa prescription prices comparison [url=http://canadianpharmacymim.com/]london drugs canada[/url]
canadian pharmacy online canada
canadian rx
canadian pharmacy 365
canadian drugstore
pharmacy drug store
pharmacy online mexico
Incredible lots of valuable information.
http://canadianpharmacyntx.com/
cheap canadian drugs canada drugs online overseas pharmacies [url=http://canadianpharmacysilo.com/]canadian pharcharmy[/url]
canadian drug stores online
buy prescription drugs online
canada drugs
canada pharmacies without script
best canadian prescription prices
canada meds
With thanks, Plenty of info.
http://www.canadianpharmacymsn.com/
costco pharmacy pricing online pharmacies of canada canadian cialis [url=https://nicktambone.com/]canadianpharmacy[/url]
canadian pharmacies online prescriptions
drug stores near me
prescription drugs canada
no prior prescription required pharmacy
canada drug prices
canadian pharmacies top best
You expressed this perfectly.
http://canadianonlinepharmacynnm.com/
online pharmacy canada canada pharmacy online canadian rx [url=http://canadianpharmacymim.com/]canadian drugs[/url]
get prescription online
buying prescription drugs canada
best price prescription drugs
canadian family pharmacy
canadadrugs.com pharmacy
international pharmacies that ship to the usa
Nicely put, Kudos!
http://www.canadianpharmacymsn.com/
canadian drug store canada pharmacy online prescription drugs online without [url=http://www.canadianpharmacymsn.com/]canada drugs online[/url]
most reliable canadian pharmacies
prescription drugs without prior prescription
my canadian pharmacy
prescription drugs prices
pharmacy online mexico
prescription drug assistance