fivetran / fivetran/dbt_quickbooks
Missing “Payroll Adjustment”, “Payroll Check”, “Sales Tax Payment”, and “Tax Payment” transaction types
- Dominant language
- No language data
- Stars
- 41
- Forks
- 48
- PR merge metrics
- No merged PRs in 30d
Description
### Is there an existing issue for this?
- [X] I have searched the existing issues
### Describe the issue
Investigating discrepancies between Quickbooks UI and the quickbooks__balance_sheet, I find that there were several transactions of type “Payroll Adjustment”, “Payroll Check”, “Sales Tax Payment”, and “Tax Payment” in Quickbooks that aren't anywhere to be found in the balance_sheet or ledger. I also looked in the raw data files and couldn't find them there either. Even though there were only a few of these transactions and only on a few days in 2021, they impact the account the payments were made from and a myriad of other balance sheet liabilities for taxes and benefits.
### Relevant error log or model output
_No response_
### Expected behavior
We expect all transactions of all types that are in the Quickbooks UI to be reflected in the relevant data models
### dbt Project configurations
# quickbooks:
using_address: true
using_bill: true
using_credit_memo: true
using_department: true
using_deposit: true
using_estimate: true
using_invoice: true
using_invoice_bundle: true
using_journal_entry: true
using_payment: true
using_refund_receipt: true
using_transfer: true
using_vendor_credit: true
using_sales_receipt: true
using_purchase_order: true
using_credit_card_payment_txn: true
### Package versions
packages:
- git: https://github.com/fivetran/dbt_quickbooks.git
revision: feature/backwards-credit-card
warn-unpinned: false
*note: using this branch to make sure we're properly counting credit card payment transactions*
### What database are you using dbt with?
bigquery
### dbt Version
unknown
### Additional Context
_No response_
### Are you willing to open a PR to help address this issue?
- [ ] Yes.
- [ ] Yes, but I will need assistance and will schedule time during our [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance
- [X] No.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.