API of Charts of Accounts

[Ahmad Yaseen Khamosh]

Hello Jacob,

I hope this message finds you well.

We are planning to integrate the Chart of Accounts from Bkper into our system. However, we have not been able to find a suitable API endpoint for retrieving all Chart of Accounts. Could you please guide us to the correct API for this?

Additionally, we would like the API to support filtering by year, similar to the functionality available in Bkper itself.

Looking forward to your guidance.

Best regards,
Khamosh

[LaCorey White]

This isn't Jacob 

--
You received this message because you are subscribed to the Google Groups "Bkper" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bkper+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/bkper/CAL2RdWjcuZ4gDJ5_Qv%2BOWWGo0gijfQLUxmhxQpQn0FhM7DC8BQ%40mail.gmail.com.

[Ahmad Yaseen Khamosh]

Sorry then who is this?

To view this discussion visit https://groups.google.com/d/msgid/bkper/CAL%3DOi6QaGiCKkmx4RzBx2YLZWdPzYZKumiP8j%3DMcbp3Fgmn%2Bow%40mail.gmail.com.

[Pedro Celso Nunes da Costa]

You're in the right place - this is a Google group used as a channel to discuss usage of bkper - every now and then Jacob answers questions posted on this group.

[]s,
Pedro Costa

Wyrd bið ful aræd

To view this discussion visit https://groups.google.com/d/msgid/bkper/CAL2RdWg-EhSZv9kPfK%3DJ_M5w7KP0JKcW5fRwykXP%2Bv6xOZZDtQ%40mail.gmail.com.

[Jacob van den Berg]

Hi Khamosh,

Can you help us understand a bit more about how you are trying to retrieve the Chart of Accounts? 

Are you using  the rest API,  bkper-js or bkper-gs library?

Jacob 

[Ahmad Yaseen Khamosh]

Thank you for your response, 
I am using Rest API of bkper v5, so you see we have chart of accounts in bkper, where we have groups and accounts whit in them, the same way i want to have in my system as well, even though I did some work around but i faced with two major issues, one is I am getting asset values as negative while in bkper its positive, second filter by year is not working, so I was wondering if we have any api that returns chart of accounts the same way as it dose in bkper that will help a lot.

To view this discussion visit https://groups.google.com/d/msgid/bkper/e0385bf2-2f70-49ef-912e-61c2df96ee07n%40googlegroups.com.

[Ahmad Yaseen Khamosh]

Thank you for your email
But It dose not return the hierarchy i just returns group name but I don't see any child of that group and accounts of the groups 

On Tue, 19 Aug 2025 at 16:50, 'Jacob van den Berg' via Bkper <bk...@googlegroups.com> wrote:

Using the Rest API

GET .../api/bkper/v5/books?query=on:2024&fields=items(accounts,groups)

This returns the books with all Accounts and Groups.

Please let us know if this is what you were looking for, okay?

To view this discussion visit https://groups.google.com/d/msgid/bkper/b3824b7a-1112-4751-a7b3-58c869291468n%40googlegroups.com.

[Jacob van den Berg]

Hi Khamosh

Actually the suggestion I gave was not the best one. 

I believe that what you are looking for is this 

 GET /bkper/v5/books/{bookId}?loadAccounts=true&key={yourkey}

It returns the book information plus the complete Chart of Accounts with:
  - All accounts with their properties, groups, types, and balances
  - All groups with their hierarchical structure
  - Account classifications (ASSET, LIABILITY, INCOMING, OUTGOING)

For the data range there's no built-in parameter, so you can try to work with:
1. hasTransactionPosted: true/false
2. createdAt timestamps

Apologies for the previous idea, I believe that with this endpoint you get what you need. 

Please let us know how this works! 

Jacob