Excel and Caseware

Excel and Caseware

Didn't find your answer?

Until recently I produced accounts for my clients using an old accounting software package ( which is easy to use) and then simply lifted the trial balance and manually entered the figures into the 'Working Trial Balance' within Caseware accounts. This has served me well for quite some time. However, it is obviously more efficient to produce a Trial Balance using Excel spreadsheets and (hopefully) at the click of a button, automatically uplift the figures into Caseware. There's a trade-off, initially, in that using Excel may take longer than using my antiquated accounting package; on the other hand feeding the figures manually into Caseware takes around 30 minutes, instead of a few second( I would hope). Do we have any Caseware users who have gone down this path? How would I most easily go about doing this? Any tips?
Thanks.
STEPHEN DODSON

Replies (4)

Please login or register to join the discussion.

avatar
By AnonymousUser
23rd Nov 2007 22:14

import feature
Once you've finished working the Excel TB, save a copy as a csv file within Excel.

In Caseware choose FILE - IMPORT - ASCII TEXT FILE, then browse for the file you've just saved, you will have to choose 'all file types' in the file browser window otherwise it won't show.

You should see a preview of the file in the preview window.

Click layout

You then highlight a section of each column that contains each segment of data in the preview window and it will tell you what ref number to enter in the layout areas

e.g. if column A of your Excel sheet contains account code then you'd enter 1 against 'account code' in the layout tab and so on.

You dont need to enter all fields, just those you need.

You can save a file containing a 'blueprint' of where each segment of your data lies for future use so you don't have to tell it each time.

You can import directly from certain other accounts software as listed in the 'import from' list.

Sounds long winded but once you've done it once or twice its a doddle. I used this feature quite heavily for a large consolidations project I did recently, where the numbers constantly changed and this was the only way I could keep up to date without pulling my hair out!

I've used CW for 10 years now and would highly recommend it to anyone.

Thanks (0)
avatar
By richardterhorst
25th Nov 2007 17:32

Caseware
I used Caseware in South Africa. One of the add-ins was a fully useable accounting add-in with management account reporting
My understanding is in any case that you can use it as a bookkeeping program albeit limited compared to Pastel and Accpac

Thanks (0)
avatar
By AnonymousUser
25th Nov 2007 20:20

Many thanks
Thank you Richard and Samuel for your helpful replies, which I appreciate very much.

Thanks (0)
avatar
By listerramjet
26th Nov 2007 10:58

worth remembering
that CASEWARE is particularly good at importing data, whether that is a TB, or a set of transactions, and via its mapping functionality reanalysing chart of accounts to the caseware format. Excel is one possible import, but it can take many others. When I used to use caseware I regularly captured client TBs from many different ledger applications, and imported them to CASEWARE.

For those of a nervous disposition I think that the CASEWARE suppliers used to be a good source of information/help. http://www.credencesoftware.co.uk/

Thanks (0)