10/23/2021
Part 2: How To Organize Your Business Expenses
If your bank has the capability of pulling excel or csv reports, please save yourself some time and use the method on this video!
If you’re good in excel, this method could take you as little as one hour to categorize your transactions for the year!
Option 2:
*
*
*
Step 1: Log into your bank and save down your bank statements in excel or csv format.
Step 2: If your bank limits the amount of data you can pull at once, save down all your reports and then merge them all into one excel file. You can just copy/paste the data below each other into one file.
Step 3: There will already be columns in your excel file, but you will need to manually add one titled “Category”. Just like my last video, you can also add a column for “description” if you want to take it a step further.
Step 4: Next to each transaction, make sure to list a category. These categories should be the ones that you will put on your Schedule C (will post a list soon).
Step 5: Do sum totals at the bottom for each category.
If you have any questions, drop a comment below or DM me!!