Unable to link Bank Accounts with Categories?

Currently, when pulling Bank Transaction Explanations, the bank_account field indicates which bank account is associated with the BTE.

However, when pulling Bank Accounts, there is no category field to indicate the accounting category of the bank account. This means that we currently have no way of knowing the accounting impact of a Bank Transaction Explanation.

Are there any plans to support this?

Thanks,

Matt

Hello Matt!

When pulling the bank_transaction_explanations or bank_transactions (contains the former) from the API, you should receive for each explanation a category which contains the url of the accounting category (see FreeAgent Developer Dashboard)

This can be queried to get more information about the category (FreeAgent Developer Dashboard)

I am not entirely sure if that answers your question so let me know

Thanks,

Florent

Hi Florent,

Thanks very much for your reply.

Here’s an example accounting entry which could be pulled from bank_transaction_explanations:

Dr Bank 10
Cr Sales 10

The category field only tells me the accounting category of the “Sales” account; it doesn’t tell me the accounting category of the “Bank” account. There’s no way for me to know which nominal account (category) is associated with the bank account which was impacted by the transaction, so I’ve effectively only got one half of the journal entry.

bank_transaction_explanations does have a bank_account field, but as mentioned, there doesn’t seem to be any way I can link this to an accounting category via FreeAgent’s API.

Thanks for your help, and I look forward to hearing from you.

Matt

Right, sorry about the misunderstanding

It is indeed not supported. There is a convoluted way to get that information currently : the list all categories endpoint with sub_account=true (FreeAgent Developer Dashboard) will return all the bank accounts with their nominal code.

The bank account nominal code should be in order of their creation 750-X with X iterating from 1

Thanks,

Florent

Thanks Florent, much appreciated!

I think this should work for what we’re trying to accomplish, although presumably it only works since FreeAgent enforces the uniqueness of bank account names (since that’s the only field we can search on)?

Thanks,

Matt

No worries, sorry to not have a more satisfactory solution for now.
The name will indeed be unique. The order of X (in 750-X) will also have the same order as the bank account ids if that helps (since they are both in order of bank account creation)

Florent