Import Accounting Data Via CSV Trial Balance

Import Accounting Data Via CSV Trial Balance New Ability to use Reach Reporting Through a CSV Upload: Available April 10, 2020 

Upload CSV Financial data into Reach Reporting | Visual Financial Reporting

In a Trial Balance, any Balance Sheet accounts will show the ending balance of that month. For any Profit and Loss accounts, they will show the cumulative ending balance of the fiscal year. Make sure not to show the activity or monthly change but the actual cumulative fiscal ending balance.

You can now connect a company through CSV. This feature was developed for advanced accountants who are typically using Excel or Google Sheets that export Trial Balance Data and then remap and regroup accounts. Reach CSV Import will upload both the Income Statement and the Balance Sheet.

First: Select "Add Company" and then choose the Upload CSV Trial Balance button.

 

connect to quickbooks

 

You can download a CSV template and easily copy and paste your trial balance data or create a new tab in an existing spreadsheet. 

Second: Follow these formatting rules;

 

account spreadsheet

 

*Columns A, B, and D are mandatory. 

*Column C allows you to have parents and sub-accounts. 

*Column E - You must have the beginning of the monthly dates. You can begin in any month and then have the date range continue, as shown above. The template you can download also includes this information. If your data is quarterly or annually, enter the total trial balance for the applicable period. For example, put Q1 data as of 3/31/2020 in the monthly column.

*Column D The account Type list is shown below. You must only use these account types so Reach is able to build your templates. Within Reach, you can always include other monthly data.

 

assets and liabilities

 

NOTE: Make sure you follow the standards of keeping your debits and credits formatted with the correct sign so that it is in balance. Reach will automatically change these so that they work in the financial metrics and statements. This means less work for you!

A list of how Trial Balance data is changed is shown below.

 

accounts payable

When you create multiple companies using the CSV upload, you can also use Consolidations within Reach Reporting.

As a Note: The trial balance does not include cash flow statement data, so some pre-existing templates may be blank. 

 

Goto the Reach Reporting app>

ARE YOU NOT CURRENTLY USING REACH REPORTING?

learn more at reachreporting.com

We are dedicated to helping you.

- Need Additional Help?

Your success is important to us.

Whether you're working as a CFO of a business or part of an accounting firm, Reach Reporting is here to improve your working knowledge of reporting and provide service tips and skills to ensure you're at the top of your game. 

We make sure that you have access to staff members that are best suited to help you. We work together to resolve issues and create memorable moments that empower you to enhance your reporting skills.

We are here to listen to you. We understand that using new technology can be frustrating, so we can answer questions or jump on a quick zoom call. Our entire staff has an in-depth knowledge of Reach Reporting and can quickly direct you to best practices to improve your reporting. 

We are here focused on providing solutions that save you time and increase your value. We continue to improve each day and look forward to visiting with you. Your communication with us is vital and appreciated. 

Please feel free to chat with us by clicking the help chat bubble in the lower right-hand corner of this page.

Reach out to your Reach Reporting Rep and schedule a zoom meeting by clicking the meeting link in their email signature.

Or schedule an onboarding zoom call with Ryan Anderson, our Chief Architect, by going to the onboarding calendar

Reach Reporting is dedicated to helping provide a knowledge base that is easy to understand and informative. If you still have questions that have not been answered, please let us know by emailing support@reachreporting.com, chatting with our support team, or calling us at (877) 467-7637. We are here to ensure that you have a positive experience with Reach Reporting, as we want to continue to be the reporting solution you trust. 

Need more access to Reach Reporting Resources?

Reach Reporting has a wealth of knowledge and a robust online community to support you as you create reports that provide powerful insight. Please look into the following resources.

Reach Reporting Blog: We add blogs to our site every month to give you great information in a fun and friendly manner.

Case Studies: We interview one company per month to help our clients highlight how they are using Reach Reporting and how it is improving their services and firm offerings. These case studies are invaluable to our community.

Knowledge Center: From simple to complicated, we provide step-by-step guidance to utilize every aspect of Reach Reporting in our robust knowledge center.

Video Tutorials: We know watching is sometimes easier than reading, which is why all of our tutorials are video-based in the video tutorial section of Reach Reporting and Youtube.

Social Networks: Join us on FaceBook, LinkedIn, Youtube, and Twitter.

Competitor Comparisons: We have looked at all the reporting solutions on the market. We provide you with an in-depth look at Reach Reporting compared to some of the strongest competitors out there on our competitor comparison page

Monthly Newsletter: Go to the footer of reachreporting.com and sign up to receive the Reach Reporting newsletters delivered directly to your inbox. Our newsletters cover tips and tricks, current events in accounting, strategies to improve your advisory services, and much more.

We look forward to helping you build insightful reports,

The Reach Reporting Team.