Difference between revisions of "Monthly Data Entry"
Tim Peeler (talk | contribs) |
|||
| (10 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | ==== Explanation ==== | + | __FORCETOC__ |
| − | + | ==== '''Explanation''' ==== | |
The "Monthly Data Entry" section of our tool is where you enter key metrics for your business such as Sales, Cost of Goods, and Total Expenses. In order to create an accurate picture of your business, please include at least 3 years of financial data. | The "Monthly Data Entry" section of our tool is where you enter key metrics for your business such as Sales, Cost of Goods, and Total Expenses. In order to create an accurate picture of your business, please include at least 3 years of financial data. | ||
| − | ==== Instructions ==== | + | ==== '''Instructions''' ==== |
| − | At minimum you will need to enter [[Tracking - Sales|'''Sales''']], [[Tracking - Cost of Goods|'''Cost of Goods''']] and [[Tracking - Total Expenses|'''Total Expenses''']] | + | At minimum you will need to enter [[Tracking - Sales|'''Sales''']], [[Tracking - Cost of Goods|'''Cost of Goods''']] and [[Tracking - Total Expenses|'''Total Expenses''']] up to the most recent month in which you have this data. By providing these data points for each month of the current year and for at least 2 years prior, our [[Budget Planning|'''Budget Planning''']] system can create a customized budget designed specifically for your business, and our [[Preset GAAP KPIs|'''Preset GAAP KPIs''']] system can track your performance to budget. By providing full data -- including [[Tracking - Cash|'''Cash''']], [[Tracking - Accounts Receivable|'''Accounts Receivable''']], [[Tracking - Accounts Payable|'''Accounts Payable''']], [[Tracking - One PR Cycle - Gross (Avg)|'''One PR Cycle - Gross (Avg)''']], [[Tracking - Monthly PR - Gross|'''Monthly PR - Gross''']], [[Tracking - Backlog|'''Backlog''']], [[Tracking - Total Assets|'''Total Assets''']], [[Tracking - Net Worth|'''Net Worth''']], [[Tracking - Transportation Costs|'''Transportation Costs''']] and [[Tracking - Shrink|'''Shrink''']] -- we can customize our [[Preset GAAP KPIs|'''Preset GAAP KPIs''']] and [[Preset Benchmark KPIs|'''Preset Benchmark KPIs''']] to your businesses personality. |
To get the minimum benefit from Profit Navigator, simply provide 3 years of "Total Sales", "Cost of Goods", and "Total Expenses" for each month for the current year. As you move from field to field in the data entry section, [https://profitnavigator.net '''Profit Navigator'''] will automatically save the data you entered. Fill out as much information as you can. If you need assistance, you can contact the [[Contact Us|'''Help Desk''']] or you may have your [[Alliance Partner Role|'''Alliance Partner / Business Advisor''']] complete this section with you. You may also take advantage of our [[Guided Tutorials|'''Guided Tutorials''']] by clicking the ''Tutorials'' link in the menu within [https://profitnavigator.net '''Profit Navigator''']. | To get the minimum benefit from Profit Navigator, simply provide 3 years of "Total Sales", "Cost of Goods", and "Total Expenses" for each month for the current year. As you move from field to field in the data entry section, [https://profitnavigator.net '''Profit Navigator'''] will automatically save the data you entered. Fill out as much information as you can. If you need assistance, you can contact the [[Contact Us|'''Help Desk''']] or you may have your [[Alliance Partner Role|'''Alliance Partner / Business Advisor''']] complete this section with you. You may also take advantage of our [[Guided Tutorials|'''Guided Tutorials''']] by clicking the ''Tutorials'' link in the menu within [https://profitnavigator.net '''Profit Navigator''']. | ||
| Line 14: | Line 14: | ||
| − | '''There are a few different ways that you can add and update your business’s monthly data. You can add your data manually or by linking your Quickbooks account. | + | '''There are a few different ways that you can add and update your business’s monthly data. You can add your data manually, import from an Excel Spreadsheet or by linking your Quickbooks account. |
''' | ''' | ||
| − | ===== To Add Data Manually ===== | + | |
| + | ===== '''To Add Data Manually''' ===== | ||
On the "Monthly Data Entry" page in [https://profitnavigator.net '''Profit Navigator'''], you can manually enter and update monthly data by clicking on a yellow box (yellow represents a data point that you can enter manually throughout Profit Navigator). You can also add additional years by clicking on “Add Year”, which is located to the immediate right of the years already added at the top left of the page. | On the "Monthly Data Entry" page in [https://profitnavigator.net '''Profit Navigator'''], you can manually enter and update monthly data by clicking on a yellow box (yellow represents a data point that you can enter manually throughout Profit Navigator). You can also add additional years by clicking on “Add Year”, which is located to the immediate right of the years already added at the top left of the page. | ||
| − | ===== To Add Data by Linking Quickbooks ===== | + | ===== '''To Import From an Excel Spreadsheet''' ===== |
| + | The second way you can enter data is by exporting your data from Quickbooks Online or Quickbooks Desktop as an Excel spreadsheet and then using the [[Import Data|'''Import Data Tool''']] to import your data. Detailed instructions and a short tutorial video are available in the [[Import Data|'''Import Data''' Section]]. | ||
| + | |||
| + | ===== '''To Add Data by Linking Quickbooks''' ===== | ||
| − | The | + | The final way you can enter data is by linking Quickbooks using our easy to use [[Import Data|'''Quickbooks importer tools''']]. To import using Quickbooks, follow the instructions in the [[Import Data|'''Import Data''' section.]]. |
| − | ==== For Advanced Learners ==== | + | ==== '''For Advanced Learners''' ==== |
The more years you are tracking, the smarter [https://profitnavigator.net '''Profit Navigator'''] will be. | The more years you are tracking, the smarter [https://profitnavigator.net '''Profit Navigator'''] will be. | ||
Latest revision as of 14:00, 6 August 2019
Contents
Explanation
The "Monthly Data Entry" section of our tool is where you enter key metrics for your business such as Sales, Cost of Goods, and Total Expenses. In order to create an accurate picture of your business, please include at least 3 years of financial data.
Instructions
At minimum you will need to enter Sales, Cost of Goods and Total Expenses up to the most recent month in which you have this data. By providing these data points for each month of the current year and for at least 2 years prior, our Budget Planning system can create a customized budget designed specifically for your business, and our Preset GAAP KPIs system can track your performance to budget. By providing full data -- including Cash, Accounts Receivable, Accounts Payable, One PR Cycle - Gross (Avg), Monthly PR - Gross, Backlog, Total Assets, Net Worth, Transportation Costs and Shrink -- we can customize our Preset GAAP KPIs and Preset Benchmark KPIs to your businesses personality.
To get the minimum benefit from Profit Navigator, simply provide 3 years of "Total Sales", "Cost of Goods", and "Total Expenses" for each month for the current year. As you move from field to field in the data entry section, Profit Navigator will automatically save the data you entered. Fill out as much information as you can. If you need assistance, you can contact the Help Desk or you may have your Alliance Partner / Business Advisor complete this section with you. You may also take advantage of our Guided Tutorials by clicking the Tutorials link in the menu within Profit Navigator.
When you have completed entering your data for at least 3 years, you will be ready to create a budget.
There are a few different ways that you can add and update your business’s monthly data. You can add your data manually, import from an Excel Spreadsheet or by linking your Quickbooks account.
To Add Data Manually
On the "Monthly Data Entry" page in Profit Navigator, you can manually enter and update monthly data by clicking on a yellow box (yellow represents a data point that you can enter manually throughout Profit Navigator). You can also add additional years by clicking on “Add Year”, which is located to the immediate right of the years already added at the top left of the page.
To Import From an Excel Spreadsheet
The second way you can enter data is by exporting your data from Quickbooks Online or Quickbooks Desktop as an Excel spreadsheet and then using the Import Data Tool to import your data. Detailed instructions and a short tutorial video are available in the Import Data Section.
To Add Data by Linking Quickbooks
The final way you can enter data is by linking Quickbooks using our easy to use Quickbooks importer tools. To import using Quickbooks, follow the instructions in the Import Data section..
For Advanced Learners
The more years you are tracking, the smarter Profit Navigator will be.
