I am trying to transfer certain data from my base to my QuickBooks account. I zap over all purchases made via Amazon into mommy expenses in QuickBooks. How can I zap over my department names into the class section of "expenses" in QuickBooks?
Question
How to transfer department names from Airtable to QuickBooks expenses
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Community Manager
Hi and welcome to the Community,
I’d have thought that you’d need to use a lookup table to convert the department names send over from Airtable into the relevant ID for the expense class. That way you could use the Custom value option and select the class ID value that’s output by the lookup table.
If you’ve not worked with lookup tables in Zaps before you can find out more about how to set them up here: Create lookup tables in Zaps
Hope that helps. If you run into any issues on that or have any questions just let us know! 🙂
+11- Community Manager
Hey there
Just wondering how things went with the lookup table I suggested—did it do the trick?
Let me know if you’re stuck at all, happy to help if you need anything!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.