fivetran / fivetran/dbt_quickbooks

Missing “Payroll Adjustment”, “Payroll Check”, “Sales Tax Payment”, and “Tax Payment” transaction types

Open
#55 4 comments 0 reactions 0 assignees View on GitHub
type:wontfix
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.