A successful import should look something like this: target-quickbooks - INFO - Converting MAR21 REV_REC (2). The debits and credits must be equal to make the entry balanced and allow QuickBooks to post the entry. Enter the debit or credit amount for the account you've selected into the Debit or Credit columns. You can also select the first account from a drop-down menu in the Account column. If any errors occur while sending the Journal Entries you will see the errors directly in your console. Enter the general ledger account number In the Account column. Now we can run the target, and send our data to QBO! target-quickbooks -config config.json Note: The target expects the file to be named exactly JournalEntries.csv Step 4: Send the data to Quickbooks Online Save your JournalEntries.csv file to the folder you specified in input_path for me, that is tests Make sure to set sandbox to false if you’re not using a sandbox QBO account.
![quickbooks journal entry debit credit quickbooks journal entry debit credit](http://2.bp.blogspot.com/-2zcASWrL_7Y/TZXcOMTswXI/AAAAAAAAAsQ/GSA8dajNIGA/s1600/Parallels+Picture.png)
Here is an example config: įill in your credentials, and save this to a file called config.json in the local directory. This will specify our OAuth credentials, where it should look for our CSV file, and some QBO specific settings.
#QUICKBOOKS JOURNAL ENTRY DEBIT CREDIT HOW TO#
If you’re not familiar with how to complete an OAuth authorization flow, you can follow the hotglue docs. This process is already well-documented by Quickbooks, so I’ll assume you can follow that guide. Step 3: Configure the target Get the OAuth credentialsįirst off, you’re going to need Quickbooks OAuth credentials. These commands may vary depending on your OS and Python version.
![quickbooks journal entry debit credit quickbooks journal entry debit credit](https://i1.wp.com/tutorstips.com/wp-content/uploads/2018/03/opening-journal-entry.png)
# Create the virtual env $ python3 -m venv ~/env/target-quickbooks # Activate the virtual env $ source ~/env/target-quickbooks/bin/activate # Install the dependencies $ pip install git+ # Create a workspace for this $ mkdir quickbooks-import # Enter the directory $ cd quickbooks-import To avoid dependency hell, I highly recommend running through this example in a virtual environment. Example JournalEntries.csv file Step 2: Set up our environment Create the virtualenv