What the Daybook is
Sage 50 is the desktop version of Sage. It does not connect to Project Commander directly. Instead, the Daybook gathers your sales or purchase transactions for a date range into a spreadsheet laid out for Sage 50. You then import that file into Sage 50 yourself.
The Daybook remembers what you have exported, so each transaction only goes into one file.
Where to find it
From the sidebar, under Company, click Daybook.
The Daybook item only appears when Sage 50 is switched on for your company. Anyone in the company can then open it — it needs no extra permission.
To switch Sage 50 on, a Super Admin goes to Settings > System > Connections. On the Sage 50 card ("Allow Sage 50 CSV export"), they click Enable.
Exporting to Sage 50
- 1
Under Export Options, click Sales Data or Purchase Data.
- 2
Click the From Date box and pick the first day of the period.
- 3
Click the To Date box and pick the last day of the period.
- 4
Click Show Data to check the transactions before you export them. This step is optional.
- 5
Click Generate CSV. The file downloads.
- 6
Import the file into Sage 50.
The file only holds transactions that have not been exported before. As soon as it downloads, those transactions are marked as exported, with today's date.
If you leave a date empty, you see "Please select both a from and to date." If the From Date is after the To Date, you see "From date must be before the to date."
The file downloads as an Excel workbook (.xlsx), even though the button says Generate CSV. It is named after the type and dates (e.g. sage-50-sales-01102026-31102026.xlsx). If your Sage 50 only imports CSV files, open the workbook in Excel and save it as CSV (Comma delimited) first.
Generate CSV marks every transaction in the file as exported, even if you never open the file. If you lose a file before importing it, untick Exported on those transactions (see below) and generate it again.
What each export includes
Transactions are picked by their own date — the invoice date, credit note date, work record date or payment notice date — not the date they were entered.
Sales Data
| Type | Transaction | Included when |
|---|---|---|
SI | Sales Invoices | The Invoice is Confirmed |
SC | Sales Credit Notes | Dated in the range |
Purchase Data
| Transaction Type | Transaction | Included when |
|---|---|---|
PI | Invoice Checking | Invoiced, Partially Invoiced or Fulfilled, with the supplier's invoice date in the range |
PC | Credit Notes from suppliers | Dated in the range |
PI | Direct Invoices | Dated in the range — one row for each line |
PC | Direct Credit Notes | Dated in the range — one row for each line |
PI | Subcontractor Work Records | Posted — one row for each line |
PI | Subcontractor Payment Notices | Certified |
PI | Subcontractor Invoices | Invoiced or Partially Invoiced |
The export covers every project in your company.
What the columns hold
The table and the file use the same columns. Sales and purchase names differ slightly.
| Sales column | Purchase column | What it holds |
|---|---|---|
| Type | Transaction Type | SI or SC for sales, PI or PC for purchases |
| AccountNumber | AccountNumber | The Account Number on the Client, Supplier or Subcontractor |
| NOMINAL A/C Ref | Nominal Code | The code of the account on the transaction. Work Records use the cost code. Subcontractor Payment Notices and Invoices leave it blank |
| Departmentnumber | Department Code | Always blank |
| InvoiceDate | InvoiceDate | The transaction's date |
| InvoiceNumber | Reference | Your Invoice or Credit Note number for sales. The reference entered on the transaction for purchases |
| JobId/OrderNo | Job Number | The project number and name (e.g. P1234 - Harbour View) |
| Value | Net Value | The value before VAT |
| Tax Code | Tax Code | The Sage 50 tax code (see below) |
| VAT | VAT Amount | The VAT |
Tax Code — sales rows, Direct Invoices and Direct Credit Notes use the Code set on the VAT rate. The other purchase rows work it out from the VAT rate: T0 for 0%, T5 for 5% and T1 for any other rate.
Checking what has been exported
Click Show Data to see the transactions for the type and dates you picked. Click Hide Data to close the table. Choosing Sales Data or Purchase Data again clears the table.
Once the table is showing:
- Show Previously Exported / Hide Previously Exported — show or hide the transactions already sent to Sage 50.
- Exported — the tick box on each row. Untick it to include that transaction in the next file. Tick it to leave a transaction out without exporting it.
- Date Exported — when the transaction was marked as exported.
Once a Sales Invoice is marked as exported, you can no longer revise it in Project Commander. To correct it, raise a Sales Credit Note.
Next steps
- Connections — where a Super Admin switches Sage 50 on.
- Invoices — confirm the sales Invoices that go into the sales export.
- Invoice Checking — check supplier invoices so they go into the purchase export.
- Subcontractor Invoices — record subcontractor bills that go into the purchase export.
- Clients — set the Account Number that Sage 50 matches on.