BPPnl

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

=BPPnl(account_code, year, month[[[, day], tracking_category1, option1], tracking_category2, option2])

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. 

tracking_category1 is the tracking category 1 of the record to be retrieved. 

option1 is selected tracking category 1 of the record to be retrieved.

tracking_category 2 is the tracking category 1 of the record to be retrieved. 

option2 is selected tracking category 2 of the record to be retrieved.

Example