140 likes | 167 Views
Creative Solutions Accounting Data Conversion. Michael Walpole & Joe Dombrowski. Larry C. Stemen, CPA & Associates June 28, 2006. Process Overview. 3 Phases Data Conversion Financial Statement Setup Integration
E N D
Creative Solutions Accounting Data Conversion Michael Walpole & Joe Dombrowski Larry C. Stemen, CPA & Associates June 28, 2006
Process Overview • 3 Phases • Data Conversion • Financial Statement Setup • Integration • Today, we’ll cover Data Conversion in Trial Balance and Fixed Asset Book Value entry.
Converting GoSystem Clients to CSA Trial Balance • What gets converted? • Chart of Accounts • Trial Balance (current and prior years) • Journal Entries • What’s not converted? • Trial Balance Views • Financial Statements
Converting GoSystem Clients to CSA Trial Balance • Pre-Conversion Considerations • Master Chart of Accounts for each Mgmt. Company? • Leadsheets or Account Groups • Subcodes exist for both • A Verify Option exists for only Account Groups • Rounding in GoSystem Audit (can be on or off during conversion, but off is recommended)
Converting GoSystem Clients to CSA Trial Balance • Getting Data From GoSystem Audit to Trial Balance • Find the GSA client list (one time procedure) • Select A Client • Give the client a Trial Balance Name (use the same name as GSA) • Click Import and have a nice day • Example
Converting GoSystem Clients to CSA Trial Balance • Once the client is converted… • Make sure that the Chart of Accounts, Trial Balance, and Journal Entries are accurate • Set client properties • Add the Engagement CS Module • Example
Converting GoSystem Clients to CSA Trial Balance • More post-conversion fun… • Open the Prior Period • Add a rounding journal entry • Close the Period • Example • Open the Current Period • Add a rounding journal entry • Set or Import Trial Balance Views • Views are Client specific • Setup Example • Import Example
Fixed AssetsAdding Asset Book Value • Fixed Assets CS already contains Ultra Tax asset data • This is a good thing >> it means a lot less headache for you • The bad news is that there is no asset book value data • In case anyone’s wondering, there is no way (except for some very complex programming on my part) to transfer asset data from FAS FirstStep to Fixed Assets CS
Fixed AssetsAdding Asset Book Value • To enter asset book values: • Open the client • Navigate to the Assets Page • Open an Asset (maximize this window to make navigating between assets easier) • Add the book value treatment and make sure that the Groups option is turned on • Enter the book value, method, prior depreciation, and group (rinse and repeat) • Example
Conclusion • Goal: Convert at least 5 clients from each of your management companies by next week • This is the first section of several as we transition to new software • The next presentation will cover setting up Excel Financial Statements
Have A Nice Day! • By the way, this presentation and all help documents are available on the tech help website,http://serverunder the topic CSA.