valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Question includes profit or Answer includes profit
<< < Page 1 2 3 4 5 6 7 8 9 10 > >>
Questions & Answers
Q: Not sure I understand how to process the data. I=E2=80=99m in eval mode.= I copied my data from my qb budget in csv format to the PL.csv file. I went to the budget complier and selected update =E2=80=9CUpdate Report=E2=80=9D.= I received an error message. It=E2=80=99s not clear to me how your worksheet gets the dat= a . Am I doing something wrong?
A: The Compiler imports the data from the PL.csv file when you click Update PL. This uses macros and macros must be enabled. An example PL.csv file is included in the download. You can initially test/try using the example PL.csv file. Simply download the software / extract all files to the same directory , open the Excel file compiler file that suits your excel version and then click Update PL on the Profit and Loss sheet. If macros are enabled the example data should be imported and displayed. You can then try with your own file.
Question and Answer Item 2058385 - Browse All Question and Answer Items
Q: I have just purchased and started using bas business Accounts and was wondering if their was a way to run a report to show monthly and yearly amounts for the different accounts to meet end of year requirements.
A: Total amounts for each account is displayed for each month, quarter and the full year in the Income and Expense sheets. Just scroll left to the required columns. Income Expense and Profit by month are automatically plotted on the Income and Expense by Month sheet. Individual account values are not plotted.
Question and Answer Item 2058377 - Browse All Question and Answer Items
Q: Do we have any thing related to Drilling business profitability analysis or costing spreadsheet?
A: Nothing specific for that industry but we do have a generic Profit Contribution model at https://bizpep.com/profitcontribution.html Breakeven Analysis at https://bizpep.com/pricebreakevenanalysis.html that may be of interest.
Question and Answer Item 2058367 - Browse All Question and Answer Items
Q: Would your software export cash flow projected data by job/customer from Quickbooks? For example I need AP paid by job. This seems to be the most time consuming activity to pull manually to excel from Quickbooks.
A: No it only processes Profit and Loss data. To process different data formats a completely different matching algorithm would be required.
Question and Answer Item 2058298 - Browse All Question and Answer Items
Q: I saved my 2011 monthly qbks profit and loss data in a file named PL.csv as instructed. Clicked Update PL. The 2011 qbks data appeared with 2012 monthly headings in the Month Actual column (i.e., January-12, February-12, and so on).
A: The Compiler is designed to build a 12 month budget. When you Update PL with exported PL data the dates of this data are set in the compiler. Then when you go New Budget and Apply the dates are set for the next year ie the 2011 data is exported from QuickBooks and the compiler uses this as a base for the 2012 budget. If your 2011 data has 2012 dates check your PL.csv file. If the data was exported correctly it should have 2011 dates. The budget dates are set as the year following the imported date.
Question and Answer Item 2058288 - Browse All Question and Answer Items