I currently have a zap that creates a new spreadsheet row in a Google Sheet anytime an expense is recorded in Quickbooks Online. However, if the expense has multiple line items in QBO, it doesn’t created multiple rows in the Google Sheet; rather, the zap combines all components of the expense onto the single row. Is there a way to have the zap create separate spreadsheet rows in Google Sheets for each line item of a journal entry in QBO?
Quickbooks Online to Google Sheets: Is it possible to create separate spreadsheet rows for each line of a journal entry?
Hi there
Amazing - thank you
Is there also a way to exclude certain lines of the journal entry?
For example: I create a journal entry in QBO that splits an expense into three different accounts (1001, 1002, and 1003). I’d like to create rows in a google sheet for account 1001 only (in other words, I’m hoping to exclude any transactions linked to 1002 and 1003 from the google sheet). Is there a filter setup so the zap only pulls certain lines of the journal entry and excludes others?
Thanks again!
Hi
Yes, you may use Filter by Zapier to exclude certain lines or even data from your journal entry.
This topic also exists on our community:
For example, let’s say I make this journal entry in QBO to classify a credit card transaction:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/c3b55f6f-e1f2-46f0-a169-f059da804c0b.png)
My hope is to record the “8401 Auto Expense” line item of that journal to a Google Sheet, so I set up a Filter:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/60b1fcec-4691-4809-9e87-64676219f12c.png)
This triggers these rows on the Google Sheet:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/dd19985f-f4ea-40e0-8eeb-91c5a93d31de.png)
The first line is perfect, but I’m hoping that the “6302 Office Expenses” line item is excluded. Is there a filter set-up to achieve this?
Thanks!
(as an aside, is there anyway to change my username…?)
I’ve unmarked that for you.
To change your username, please email us at community@zapier.com from the email you registered your Zapier.com account from for security and verification purposes before we update your name. Thanks!
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/19e94a77-f500-4265-89d4-6b0c9924bfe8.png)
It should look green like this if it worked:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/55192be3-f5ff-4908-abde-5fbab3f1e647.png)
Is there a way to set up a step to delete a row in a google sheet IF it doesn’t contain certain data? In other words, could I create a next step in the zap that then searched the spreadsheet rows, and, if the row did not contain “8401”, the row would be deleted?
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/72a6c359-123c-409a-9fa8-557b75aba5a6.png)
Is there a way to set the Row value to be such that it only deletes rows that do not contain “8401”?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.