Generates a formatted .iif file from a csv of your expense report.
Steps:
- Click "Download Zip" on the right.
- Open the Zip.
- Put your expense report in the quickbooks_formatter folder that was just created (NOTE: make sure the first line of your expense report includes columns with the exact titles of DATE, ITEM, and COST).
- Open the formatter.py script in a text editor.
- Inside the quotations, fill in values for ACCOUNT_NAME (the name of your account) and TAX_REPORT (the full name of the expense report file you just placed in the folder).
- On a Mac, open up Terminal, on a Windows machine open up a Command Prompt.
- Navigate to the quickbooks_formatter directory using the "cd" command.
- Type the command "python formatter.py" and press enter.
- Enjoy your formatted file!