Confirmation.com - Caseware Working Papers | How to use calculated journals and linking calculation to MS excel

Due to increased volumes during the busy season (January–March) all banks will operate on a 20-business-day SLA excluding weekends and public holidays. Our team remains available to support you during this period.
  1. Home
  2. Knowledge Base
  3. Caseware Working Papers | How to use calculated journals and linking calculation to MS excel
FAQ

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: 
  (Popularity = 4/100, Rating = 0.0/5)

   Related Articles

Getting Started | Posting journal entries
What to do when an adjusting journal entry does not pull through to the financial statements?
User Profile for Bank Users Set Up
How do I set up a Consolidation/Group figures in Caseware Working Papers?
view all...


   Search Results

Retrieving Completed Confirmations
Financial Statements | iXBRL | How do I complete the submission to CIPC, after exporting to the document manager?
What does the Completed Confirmation Report provide?
Reconfirming/Querying a Completed Confirmation
Probe | Completing a work program
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
Confirmation.com
For more information, visit: www.confirmation.com

Adapt IT logo

Quick Links


Knowledge Base
Privacy Policy
Security
Regulatory
Terms Of Service
Copyright © 2026 | All Rights Reserved