Caseware Working Papers | How to use calculated journals and linking calculation to MS excel

Published: 14/06/2023

How to use calculated journals and linking calculation to MS excel.

Answer:

On the Journal Entry screen in the Document Manager, select the ‘Calculated’ checkbox

User-added image

Open the MS Excel workbook and copy the relevant cell that should be linked using either the right-click | Copy option or the ‘CTRL + C’ hotkey.
Paste the copied value in the ‘Calculation’ field using either the right-click | Paste or the ‘CTRL + V’ hotkey

User-added image

A link to the MS Excel workbook will be created and the balance will be automated from the workbook

User-added image

Note :The journal can be recalculated to update the journal to the latest balance using the Recalculate button or by selecting Tools | Recalculate Adjusting Journal Entries from the Caseware Menu.

User-added image

Rate this article:

Processing...

(Popularity = 1/100, Rating = 0.0/5)

Related Articles

Getting Started | Posting journal entries Caseware Time | How do I find the error if the amount on the invoice journal is incorrect? How do I set up a Consolidation/Group figures in Caseware Working Papers? What to do when an adjusting journal entry does not pull through to the financial statements? view all...

Search Results

How to import the trial balance from MS Excel to Caseware? Caseware Working Papers | How to use calculated journals and linking calculation to MS excel How to save automatic documents in excel and directly into the document manager Caseware IDEA Tutorials: Importing An Excel Spreadsheet How to export documents to excel? view all...

Didn't find what you were looking for?

Watch a video

Check out our helpful video guides

Contact Support

Contact our support team

Caseware and the Caseware logo, are registered trademarks of Caseware International Inc. and are licenced for use to Caseware Africa and Adapt IT. © 2023. All rights reserved.

For more information, visit www.casewareafrica.com

If you would like to keep up to date with the latest Caseware Africa news:

YouTube

Instagram

Google

Help

FAQs How to Guides User Manuals Video Guides Error Codes Webinar Recordings Release Notes Getting Started

Quick Links

Customer Success Services Knowledge Base Product Updates About the Community Contact Support Terms of Service, EULAs and other relevant policies

Copyright © 2025 | All Rights Reserved