Questions & Answers

Q: I am starting a business and am looking for simple and effective software that will help me find my breakeven point, forecast the performance of the business and make decisions regarding the pricing of my products.

A: Pricing and Breakeven Analysis https://bizpep.com/pricebreakevenanalysis.html will identify breakeven points and optimal price points. Business Valuation Model https://bizpep.com/businessvaluation.html will provide a business forecast as does as Forecast and Budget Builder https://bizpep.com/forecastbudget.html

Question and Answer Item 2058233 - Browse All Question and Answer Items

Q: Is this a tool for SETTING a budget in quickbooks, or is it a tool for MONITORING AND MAINTAINING a budget by 1) setting it up, and 2) regularly uploading P&L data to compare to that budget.

A: It is both. It allows you to create and upload budget values to quickbooks and monitor your budget from quickbooks in this case you simply need to create the budget and iff file and import to quickbooks and you are done with the compiler. Alternatively (most common use) you use the compiler as your budget tool and set up your budget in the compiler and then as the year progresses export actual data from Qucikbooks (or input it manually if you want) for each month and monitor the budget in the compiler. If you do it this way you do not have to upload any iff data to quickbooks ie all budgeting is in the compiler but just uses the export quickbooks values to set it up and then update it with actual values.

Question and Answer Item 2058201 - Browse All Question and Answer Items

Q: Is it possible to have a sheet that graphs ONE LINE of the budget. There is a graph for the total (Actual and Budget Chart) - but I'd like to be able to produce the same graph for ANY line from the chart of accounts. This way we can see for a line item how we're doing.

A: This is not a possible from the standard compiler but you can open/save a new workbook and then link to the compiler data ie make the new workbook cells take data from the compiler so you end up with a formula like ='[New Budget.xlsm]Profit and Loss'!$M$16 . This allows you to set up any data links you like (ie line by line) and then plot as you like.

Question and Answer Item 2058199 - Browse All Question and Answer Items

Q: I have successfully uploaded a sample budget into the sample rock castle construction company. However when I upload my companies IFF file into QuicBooks half the data goes into a P&L budget half goes into a Balance Sheet budget. Please advise.

A: If imported accounts are not set up correctly in QuickBooks then Quickbooks will create bank accounts of the imported items. See the Quickbooks note ... "Caution: Make sure all accounts in your IIF file are created in QuickBooks prior to importing. If you import a transaction with an account that is not already created in the QuickBooks data file, that account will be created as a new bank account." at http://support.quickbooks.intuit.com/support/Pages/KnowledgeBa seArticle/1003348.html Possibly this is what is occurring for you ? If the PL.csv file was created (exported) from an existing company in your qucikbooks and the budget was imported back into this company then each imported item should have matched an existing item in the quickbooks file and it should have been fine. If the PL.csv file was not created from the same company that the Imp.iif file was imported to then Quickbooks will create each item as a new bank account. It is also worth noting that bank accounts represent assets/liabilities which are Balance sheet items. FYI you can manually edit the the Imp.iff file using a text editor. Also you can access a copy of the Quickbooks Iff Import Manual in the Quickbooks IFF Import Kit from https://bizpep.com/iif_import_kit.zip , this may provide further insight. I hope some of this makes sense and is applicable to your issues.

Question and Answer Item 2058198 - Browse All Question and Answer Items

Q: When working on the budget, some items I keyed directly into the budget column and others I used the %. When I hit apply nothing but what I had keyed appeared in the budget column. What did I do wrong? Cant I see my budget at this point or do I have to upload to QB's?

A: From your imported data click New Budget to create a new budget file. In this file you can set Relative Percentages to calculate budget values or directly input/adjust the budget values (in the Month Budget column). If the relative percentage is 0 (or blank) and you have not manually input a value then the Month Budget value will be 0. The month budget column is your budget values. Once you are happy with all your values click Apply to convert the formula to set values, and create your file for import to Quickbooks.

Question and Answer Item 2058187 - Browse All Question and Answer Items

<< < Page 1 2 3 4 5 6 7 8 9 10 > >>