Return the debit of an account based on the account code and period provided.
=BPTBDebit(account_code, year, month[, day])
account_code is used to get the account type from Xero. If account code not found, it will return an error.
year is the year to be retrieved in 4 digit format(yyyy)
month is the month to be retrieved from 1 to 12
day is an optional parameter. If no day provided, it will use the last day in the month. It is the day to be retrieved from 1 to 31.
Example
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article