fivetran / fivetran/dbt_quickbooks

[Bug] QBO balance sheet data doesn't make sense.

Open
#181 7 comments 0 reactions 0 assignees View on GitHub
error:forced type:bug 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

I can't understand how to read the balance sheet data pulled by the fivetran quickbooks connector. The data doesn't line up with anything in quickbooks. I would I read the balance sheet for the month of march 2025 for the Chequing Account as an example.

![Image](https://github.com/user-attachments/assets/fdf1529c-39e4-4c82-9ddd-c20f016d62fd)
[data-1745898775247.csv](https://github.com/user-attachments/files/19952334/data-1745898775247.csv)

### Relevant error log or model output

```shell

```

### Expected behavior

Monthly balance sheet rows should match with what is in quickbooks.

### Possible solution

_No response_

### dbt Project configurations

default

### Package versions

latest

### What database are you using dbt with?

postgres

### How are you running this dbt package?

Fivetran Transformations

### dbt Version

na

### Additional Context

_No response_

### Are you willing to open a PR to help address this issue?

- [ ] Yes.
- [ ] Yes, but I will need assistance.
- [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.