Accounts link

Accounts link

t3 offers integration with various external accounting systems, allowing you to post Cash Daybook batches into the Nominal Ledger of systems that support file import. This article explains the process of using the Accounts Link feature to facilitate this integration.



The accounts link window can be access through the following steps:

  1. Open the t3 application.
  2. Navigate to the Financial menu.
  3. Select "Accounts Link."

Setting Nominal Control Codes

Before using the Accounts Link for the first time, ensure that Nominal Control Codes are correctly configured in the Nominal Tab, within the settings window. These codes should match the company's Chart of Accounts as defined in the external accounting system. Note that changes to control codes do not affect existing Cash Daybook journals.


The Accounts Link form provides several functionalities for managing Cash Daybook journals waiting to be sent to the external accounting system:

  1. Toolbar Buttons: Allows you to navigate through the list

  2. Transaction List: This list displays all journals waiting for export. The columns include:

    • Nominal: Nominal Ledger Code.
    • Type: JD (Journal Debit) or JC (Journal Credit).
    • Date: Cash Daybook posting date.
    • Trans: Cash Daybook Batch Number.
    • Details: Transaction description.
    • Nett: Nett Value.
    • TC: Tax Code.
    • Tax: Tax Amount.
    • Tag: Indicates whether the transaction is selected for export (tagged) or not. Double-click to tag or untag individual items.

  3. Total Items: This shows the number of transactions in the list. You can use the file re-index utility in the maintenance section to pack this list periodically, as posted items remain invisible in the table in case re-export is required.

  4. Tagged Totals: Displays totals of tagged journal Debits and Credits. These totals must match before executing the export.

Tagging and Untagging

You can tag or untag journals individually or use the "Tag All" and "Clear Tags" buttons for batch tagging or untagging.

For further information on tagging, please refer to the article [here].

Exporting Journals

To export journals to the external accounting system, follow these steps:

  1. Ensure that you have tagged the desired journals for export.
  2. Click the "Link" button to generate the link report and write the export file to the Accounts Link folder defined in the Workstation Defaults window.

If you have any other questions about the above, please do not hesitate to contact our support team, who will be happy to help.


Opening Hours
Mon-Thu - 0900 - 1730
Friday       - 0900 - 1700
T: 01302 841333



    • Related Articles

    • Financial - Receipts, Cashbook, Sales Ledger, Nominals

      Receiving Money PHCloud has a dedicated receipts section for receiving payments against a customer's account. This includes both invoice payments and Payment On Accounts. POA's are held against that customer's account and can then be allocated ...

    • Registering Outlook & 365 Email Accounts with Open Authorisation

      What is OAuth and why is it required ? Microsoft has recently taken the decision to implement OAuth2 as the standard authentication process for online email applications. The traditional method of SMTP authentication, requiring a username and ...

    • How do I export to Sage, Xero or Quickbooks?

      Journal Exports for Sage This is for customers with the Financial Module on PHCloud using Sage Line 50. The exports will work with Sage Line 100 however may require additional field matching during import. As part of PHCloud's robust financial ...

    • Applying Travel Cost Estimations to a Quote

      How to apply distance & time based cost estimations PH Cloud has the facility to create an estimation for Vehicle and Fuel costs, when creating a quote. This article will explain how to set up and apply distance and time based cost estimations, to ...

    • Cash Day Book

      The Cash Daybook is selected from the Financial menu on the t3 shell window and shows a table of all recent payments which have been entered into the system. The payments will have been entered against bookings, sundry sales, vouchers, through the ...