You can now connect a company through a .CSV Trial Balance file. When you create multiple companies using the CSV upload, you can also use Consolidations within Reach Reporting. After upload all financial statements will be automatically created.
Download a CSV template and easily copy and paste your trial balance data. You can also create a new tab in an existing spreadsheet using the same data structure.
If adding new monthly data, you can download the previously uploaded CSV and then add the new month column and reupload.
After your CSV template is ready (formatting instructions below) select "Add Company" and then choose the Upload CSV Trial Balance button.
-1.png?width=688&height=350&name=image%20(2)-1.png)
When formatting .CSV files for import into Reach Reporting follow these formatting rules, otherwise the data may not import properly:
• Show the actual cumulative fiscal ending balance (not monthly change) in your data.
• Each account record must start on its own line.
• Header rows are required for mapping Reach Reporting fields to imported fields
Columns A, B, and D are mandatory. Column C allows you to have parent and sub-accounts. Column E must have the beginning of the monthly dates. You can begin in any month and then have the date range continue. 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.
• Make sure that mandatory columns are pre-filled and that correct mapping is used.
Account ID and Name (A & B Columns) are for General ledger account numbers and names.
Account Type (Column D) is the General ledger account type that must match the Reach Reporting account types below.
-2.png?width=688&height=234&name=image%20(3)-2.png)
• Keep your debits and credits formatted with the correct sign. Reach Reporting will automatically transform these so that they work in financial statements and metrics. Transform the data as shown below.
• Use the file type CSV UTF-8 (Comma delimited).
•Depending on your regional settings the default delimiter used to separate data in a .CSV file can be different (usually semicolon or commas). Use commas (,) to separate data.
• Use dot (.) as a decimal separator and comma (,) as a thousand separator.
• The enclosing character (double quotes) must be used when the delimiter appears in the field.
Additional notes on formatting your .CSV file with different regional settings
You can either use a CSV converter tool (many are available online for free) or use the following workaround:
• Format all cells as General.
• Save as CSV UTF-8 (Comma delimited).
• Open file in a text editor such as Notepad.
• If you are using a number format that does not have dot (.) as a decimal separator use the Replace option to replace commas with dots as shown below (CTRL+H shortcut for Notepad).
• Next using the same option replace all delimiters with commas (,) as shown below.
Go to 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 to join our onboarding webinars
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.