[Bug] balance sheet not rounding out

[fivetran-reneeli]

Is there an existing issue for this?

• [X] I have searched the existing issues

Describe the issue

Period amounts should balance out in the balance sheet but are not. This might because retained earnings should be the accumulated earnings carried over from the previous period, and this is used to balance out the classifications. However we're using retained earnings that Sage gives as a predetermined category-- we may need to calculate this manually instead.

Relevant error log or model output

No response

Expected behavior

Balance sheet needs to tie out

dbt Project configurations

n/a

Package versions

0.1.0

What database are you using dbt with?

bigquery

dbt Version

1.0.0

Additional Context

No response

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

• [X] Yes.
• [ ] Yes, but I will need assistance and will schedule time during our office hours for guidance
• [ ] No.

[fivetran-reneeli]

Issue: The balance sheet is not tying out; we should see the following classes tie out with each out for any given period:

Assets = Liability + Equity

In other words, the sum of these classes should net to 0. Currently it is not doing so, and I'm thinking it has to do with the way we're bringing in the Retained Earnings category. Sage already has a Retained Earnings category so we are bringing that in as is. Compared to our Netsuite package where it is being manually calculated. I'm thinking we'll need to do something similar.

The customer that brought up this issue has a fix in their package and mentioned they would share that with us this week (4/4).

Internal note: for query, see task ticket.

[fivetran-reneeli]

Added new account for adjusted net income to roll over net income into retained earnings. Testing with our data showed the balance sheets tying out, we will check with the customers who brought this issue up to test with these updates as well.