Created by Thomas Lo, Modified on Sun, 12 Feb, 2023 at 11:31 PM by Thomas Lo

Return the credit of an account based on the account code and period provided. 

=BPTBCredit(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. 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article