Bank transaction data doesn't load not reconciled items

I would like to bulk reconcile bank transactions. When downloading the bank transactions data, it only downloads reconciled entries. How can I download and bulk reconcile?

Hi @dbls

thank you for getting in touch.

As stated by the Xero API the Bank transactions is restricted to only pull “spend and receive money transactions, overpayments and prepayments. This endpoint does not allow access to any bank statements or direct bank feeds.” “This endpoint does not return payments applied to invoices, expense claims or transfers between bank accounts.”

I believe you can run the Journals data table and filter “Journal Lines.Account Type” by BANK to get a list of all Bank transactions.

Regards,

David

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.