12/15/2022 Training note and screenshots
Following is the agenda of the trainin
- How to find the excel import templates and a guide. Go to gosystem home page -> Help Resources ->Help Knowledgebases-> Import/Export ->DIF Import/Export ->Data Import Templates
Below is the screenshot of each steps.
After you download the templates, it will look like this.
In this example, an asset template was shown. After opening the template, it will look like this. Need to fill out the first tab information.
The second tab has asset details.
Don’t need numbers in every cell. Usually have drop down menu to choose from.
If the return has already data, can export from return, instead of using templates.
Below are process of exporting. Gosystem home page->Return Processing->Import/Export->Data Templates->Export
Choose the client, choose the templates to download from drop down menu.
After the export, to check the status of the export go to Export Batch Status. And below are the screen shot of the steps.
Below excels are the example of the exported templates from return which means, there was information in the return.
This client has Sch C. It has 3 properties. On this excel, new assets can be added and imported back into the return.
How to Import back.
Gosystem home page->Return Processing->Import/Export->Data Templates->Import-> choose the right year, client and follow the steps.
When tax return is opened, the blue data means rolled over or imported.
- Excel add in.
There is a pdf guide using excel add in. Go to gosystem home page -> Help Resources ->Help Knowledgebases-> Import/Export->Excel add In
How to download the excel:
Gosystem home page->Return Processing->Import/Export->Excel Add In-> Download the appropriate excel. In order to know which excel you have, open excel, in about section, in the below screenshot, it will show the bit.
Close excel. Make sure download the right excel.
After the template is downloaded, the excel files are by entity type.
1040 template is only for FBAR.
For business return, there are more tabs available.
The tabs can be deleted if not used.
In order to link data: Click on Data import-> New Map-> XML sources window will appear in right hand side. See below screenshot. Link the datas.
There will be register tab on top.
Partnership 1065
Bridge workbook –
There is a pdf guide of how to use the bridge workbook.
Here is the path: Go to gosystem home page -> Help Resources ->Help Knowledgebases-> Import/Export->Partner Bridge for 1065
How to access the bridge excel.
Creates diff file to import to return.
2. Rental property disposal
For the assets, there are few options.
Choose the rental and royalty->Depreciation and Amortization->Asset Detail-> Desk-> Retirement/Disposal-> check the box retire asset
Assign 2 digit number unique bulk sale identifier.
Gains loss folder in the rental property. Gain and loss info should be entered by the property types. Enter all 1245 property’s sales prices once. Enter also the unique bulk sales number previously assigned.
Don’t delete the properties under sales of Business Property.
Bulk sale: enter for entire sale not only for that property.
What is new in GS.
Power Point is provided.