12/15/2022 Training note and screenshots

 

Following is the agenda of the traininGraphical user interface, text, application, email

Description automatically generated

  1. 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.

Graphical user interface, text, application, email

Description automatically generated

 

Graphical user interface

Description automatically generated

 

Graphical user interface

Description automatically generated

Table

Description automatically generated

After you download the templates, it will look like this.

Text, table

Description automatically generated with medium confidence

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.

Graphical user interface, application, table

Description automatically generated

The second tab has asset details.

Graphical user interface, application, table, Excel

Description automatically generated

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

Table

Description automatically generated

Graphical user interface, text, application

Description automatically generated

 

Choose the client, choose the templates to download from drop down menu.

Graphical user interface, application

Description automatically generatedGraphical user interface, application

Description automatically generated

 

 

 

 

 

 

 

 

After the export, to check the status of the export go to Export Batch Status. And below are the screen shot of the steps.

 

Graphical user interface

Description automatically generated

 

Graphical user interface, text, application

Description automatically generatedGraphical user interface, text, application, website

Description automatically generated

 

Below excels are the example of the exported templates from return which means, there was information in the return.

Text, letter

Description automatically generated

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.

 

 

Graphical user interface, application

Description automatically generated

When tax return is opened, the blue data means rolled over or imported.

 

  1. 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

Graphical user interface, text, application, email

Description automatically generated

 

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.

Text

Description automatically generated

Graphical user interface, application

Description automatically generated

Close excel.  Make sure download the right excel.

 

 

Graphical user interface, text, application, email

Description automatically generated

After the template is downloaded, the excel files are by entity type.

 

 

Text

Description automatically generated

 

 

1040 template is only for FBAR.

 

Graphical user interface, application, table

Description automatically generated

For business return, there are more tabs available.

Graphical user interface, application, table, Excel

Description automatically generated

 

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.

Graphical user interface, application, table, Excel

Description automatically generated

There will be register tab on top.

 

Table

Description automatically generated

 

 

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.

 

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, application

Description automatically generated

 

Graphical user interface

Description automatically generated

 

Creates diff file to import to return.

 


 

2. Rental property disposal

 

Graphical user interface, text, application, email

Description automatically generated

 

Graphical user interface, text, application

Description automatically generated



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



Graphical user interface, text, application

Description automatically generated

 

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.

Graphical user interface, text, application

Description automatically generated

 

 

Graphical user interface, application

Description automatically generated

Graphical user interface, text, application

Description automatically generated

 

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.