Twinfield Analysis provides means to import data from your Twinfield companies into Excel.

Twinfield Analysis extracts the data from a company directly into Microsoft Excel. These Excel spreadsheets are linked securely to the Twinfield company or companies. This method can update data continuously while the layout and calculations are retained.

Twinfield Analysis operates with datasets (known as ‘cubes’) that are used to retrieve data from Twinfield. The data can be retrieved from one or several companies at the same time and will then be collated in a single Excel spreadsheet. This information can be used to perform various analysis and set up the desired reports.

Twinfield Analysis requires Microsoft 365 version of Excel.

Adding Twinfield Analysis to Excel

Twinfield Analysis is an addin from the Microsoft Office store and can be added from the Insert Ribbon within Microsoft Excel by clicking on Get Add-ins

clipboard_e9e1a67d52cbb89a95b823c4bd165821a.png

From the Office Add-ins, select Store and search for Twinfield

clipboard_e53b40d86ef9de83d7f4ef58605396367.png

Click Add against Twinfield Analysis to complete the install

Related documents

Cheques and Paying-in slips
Cheques and Paying-in slips.
Twinfield: Twinfield Analysis Consultancy (10091307)
This document outlines a training course on Twinfield accounting software, designed for Twinfield partners and subscribers. The course, lasting up to 3 hours, focuses on enabling participants to leverage their Excel expertise to manipulate TwinCube data for creating comprehensive financial reports. Key objectives include processing transactions and searching via the reporting module. The session covers various topics such as data cube management, Excel formula building, and conditional formatting. Attendees must have advanced Excel skills and their own devices to join the session, as the course is tailored for Microsoft Windows users.
Twinfield Consultancy (10093303/10080551)
This document outlines a consultancy service for Twinfield users, targeting both partners and subscribers. It emphasizes collaborative sessions aimed at improving operational efficiencies and best practices through tailored advice and process reviews. Conducted online or onsite over two 3-hour sessions, the consultancy covers topics such as reporting, VAT reporting, and reconciliations. Attendees are expected to have a solid grasp of double entry bookkeeping. Additional resources, including eLearning courses, videos, and webinars, are provided for further learning.
Twinfield: Integration Consultancy (10095230/10095228)
This document outlines a consultancy-led course focused on the Twinfield accounting software, designed to assist businesses in managing their financials effectively. The course consists of four interactive sessions—each lasting three hours—covering navigation, invoicing, credit management, transactions, and reporting. Aimed at Twinfield partners and subscribers, participants are expected to have a good understanding of bookkeeping principles. Additional resources such as eLearning courses, videos, and webinars are also provided to enhance learning. The maximum group size is six delegates.
Twinfield: PM Integration Consultancy (10091304/10091303)
This document outlines a training course for Twinfield accounting software users, focusing on its integration with CCH Central. The course consists of four sessions, each lasting about three hours, aimed at enhancing attendees' bookkeeping skills and knowledge of both systems. Key objectives include familiarization with CCH Practice Management and Twinfield, as well as hands-on experience with financial processes such as invoicing, bank transactions, and VAT reporting. Prerequisites include a good understanding of CCH Central and appropriate permissions. The course is intended for Twinfield partners and subscribers, with a maximum of six delegates per group.