Quickbooks Integration - Credit Card Credits
I am working with expenses imported from quickbooks via the built-in integration. I cannot seem to find any fields included in the imported data that indicate whether an expense is really an expense o...
Forum Discussion
What fields did you include when you set up your QBO connected table, and how do you go about recording Credits in Quickbooks?
I ask because it will determine what data to look for to differentiate between a debit/credit.
I tested a connected table using the Expert Option called "Purchases" which pulled over all transaction fields on a sample credit card account, including a check box called "Credit"
This is all we need to create a formula to drive whether the "Amount" should be a positive or negative integer.
If you have a setup similar to this, all you need is to create a formula numeric field and call it something like Amount Formula, like the following,
If([Credit]=true,(0+[AccountRefValue]),(0-[AccountRefValue]))
This will display credits as positive amounts, and everything else as negative.
Depending on how this data feeds other tables and formulas, you may find it makes more sense to switch the formula to display credits as negatives, etc. (some would consider a negative expense a credit, but you get the idea. :)
Hope that helps!