PHP · Track 3 · Tutorial 6 of 6

Read the trial balance back

Read back the month you sent, account by account, once the overnight run has rebuilt the figures.

You will needA month sent in this track, and the overnight run since.
By the endA script that reads any month, scenario or account back from BrizoConsol.

1Read September back

Create read-month.php:

read-month.php

<?php
// read-month.php - reads September's trial balance back.
require __DIR__ . '/brizo.php';

$answer = call('GET', "/organisations/$companyId/trial-balances?period=2026-09");
if ($answer['status'] !== 200) {
    exit("Refused ({$answer['status']}): {$answer['body']['message']}\n");
}

foreach ($answer['body']['data'] as $row) {
    echo str_pad($row['code'], 6) . str_pad($row['name'], 20)
        . 'debit ' . str_pad(number_format($row['debit'], 2), 12, ' ', STR_PAD_LEFT)
        . '  credit ' . str_pad(number_format($row['credit'], 2), 12, ' ', STR_PAD_LEFT) . "\n";
}
What you can ask for, and what comes back
Reading the trial balance: a month or a run of months, and each account's figures.

2Run it the next morning

The trial balance is read from the same figures as BrizoConsol's reports, so a month you sent today appears after tonight's run.

php read-month.php

Check

1000  Operating bank      debit    20,000.00  credit         0.00
1200  Trade receivables   debit     5,000.00  credit         0.00
2000  Trade payables      debit         0.00  credit     5,000.00
4000  Sales revenue       debit         0.00  credit    30,000.00
5000  Cost of sales       debit     8,000.00  credit         0.00
6000  Rent                debit     2,000.00  credit         0.00

Each account's debit and credit for the month, as you sent them.

Read it the morning after
The trial balance is read from the same figures as the reports, so read it after the overnight run.

3Ask for more

  • number_of_months=3 - the three months up to the period.
  • scenario=Budget or Forecast - the plan instead of actuals.
  • account_code=4000 - one account.
  • Each row also carries movement and balance on the account's own side, which match the statements.

Want more detail? See the documentation