Who works where
Afiavi works in the organization space of her firm. She picks the book of the client account and reads its reports, provided she has been given access to that book (see Limit access to locations and books). A client account such as the baker’s can also read the reports of its own book from the client space. Both spaces offer the same reports.Check the accounts of a period
Afiavi starts with the trial balance of March for the bakery. If a figure looks odd, she opens the general ledger of that one account. It lists the movements of the account over the period, with the opening and closing balance, page by page.See the result and the position
To answer the baker’s second question, she reads the income statement of the year so far. To show what the bakery owns and owes at the end of the month, she reads the balance sheet at that date.Follow customers and suppliers
For the first question, Afiavi opens the aged balance on the customers side. It lists what is still open and groups it by age. She opens it on the suppliers side to see what the bakery still owes its flour supplier. The third-party balance is a trial balance limited to customer accounts or to supplier accounts, grouped under their parent account.Read several books together
Sèdjro Gbaguidi’s group has a company in each city, and its accountant, Mahougnon Tossou, wants one view. In the organization space he reads a combined trial balance, balance sheet or income statement over the books he can access, or over a list of them. This combination is a plain sum: money moving between the group’s companies is not removed, so it is not a consolidation.The rules
- The accounting module must be part of the organization’s plan.
- In the organization space, the caller needs an accounting access grant on the book. In the client space the book is the client account’s own.
- Combined reports exist only in the organization space.
- The trial balance and the third-party balance need a fiscal year or a fiscal period. A range of dates alone is refused. A period wins over everything else. Without a period, a start and an end date sent together win over the year.
- The income statement needs a fiscal year, a fiscal period, or a pair of dates. A pair of dates wins over a year. The end date cannot be before the start date.
- The balance sheet is stated at a date. Without a date, it is the end of the fiscal year sent, or of the fiscal year that contains today. When no fiscal year is sent, the book must have one that contains the date, otherwise the answer is 404. Date ranges and periods sent to the balance sheet are ignored.
- The general ledger needs an account of the book. A fiscal year, when sent, replaces the dates. Without a start date the opening balance is 0. A period sent to it is ignored. A page holds 1 to 100 lines, 25 by default.
- The aged balance needs a side, customers or suppliers (vendors in the API), and a date that defaults to today. The age is counted from the accounting date of each line, not from a due date, so nothing is reported as “not due”. An item settled by a later line is still open at a date before that line.
- The third-party balance needs a type, customer or vendor.
- Combined reports take up to 100 distinct books, each one a book the caller can access. Without a list, every accessible book is combined. The combined balance sheet needs a date. The combined trial balance and income statement need a start and an end date, and fiscal years are not used.
- When a book is in another currency than the organization, a combined report converts it with the exchange rate valid on the report date. Without such a rate the report is refused.
- All amounts are whole numbers in the smallest currency unit. The response gives the scale.
All the actions of this topic
- View combined trial balance: Shows a trial balance that combines several books of the organization.
- View combined balance sheet: Shows a balance sheet that combines several books of the organization.
- View combined income statement: Shows an income statement that combines several books of the organization.
- View trial balance (organization): Shows the trial balance of one book over a period (organization space).
- View general ledger (organization): Lists the movements of one account with opening and closing balances over a period, page by page (organization space).
- View balance sheet (organization): Shows the management balance sheet of one book (organization space).
- View income statement (organization): Shows the management income statement of one book (organization space).
- View aged balance (organization): Shows open customer and supplier balances grouped by age at a chosen date (organization space).
- View third-party balance (organization): Shows the trial balance restricted to customer or supplier accounts, grouped under their parent account (organization space).
- View trial balance (client account): Shows the trial balance of one book over a period (client space).
- View general ledger (client account): Lists the movements of one account with opening and closing balances over a period, page by page (client space).
- View balance sheet (client account): Shows the management balance sheet of one book (client space).
- View income statement (client account): Shows the management income statement of one book (client space).
- View aged balance (client account): Shows open customer and supplier balances grouped by age at a chosen date (client space).
- View third-party balance (client account): Shows the trial balance restricted to customer or supplier accounts, grouped under their parent account (client space).