Questions & Answers

Q: I see you do work with files made by MYOB version 3 for Macintosh. I would like to pay someone to read some old files of mine and give me an XL file of what they say. It sounds like your product will do this.....

A: You should be able to export your data from MYOB into an Excel format. To do this from MYOB Reports, General Ledger select the Profit & Loss and export it to an Excel file. This will give you data in an Excel format. If required this can then be imported to our PL Compiler MYOB https://bizpep.com/PLCompilerMYOB.html .

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

Q: I downloaded the trial version, followed the instruction regarding macros, saved the model and reopened it and am stuck. When I try to do an "open with" Excel the .qbb file doesn't open. When I try import "get external data" "from other sources", it still won't work. Can you help?

A: I am not sure what you are doing? There are no commands/controls for .qbb files or import using "get external data" functions in this software. To use the software you Export your MYOB data to a .xls file and then this is imported to the compiler using the Update PL command button. Please mouseover the red market sells on the Profit and Loss sheet for user instructions.

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

Q: I remeber that you had a "business case generation" tool. Do you still sell it?

A: We do have Profit Contribution Breakdown software https://bizpep.com/profitcontribution.html and a range of other Excel based business software at https://bizpep.com/ . So of these titles are provided in a browser based format at https://bizpep.com/ . We do not have a specific "business case generation" tool.

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

Q: I have the software and I have QB. How do I get my 2008 Data into the Budget Compiler. I looked in File - export, but it doesn't give me the option to export P&L data. I looked at my Budget function but dont' see that either. Would I run my P&L and export it to Excel like normal and then open the file in the Budget Compiler?

A: As outlined in the Update section of the help file "... you need to place your monthly QuickBooks Profit and Loss data in a file named PL.csv in the same directory as the Compiler file. To do this from QuickBooks go Reports, Profit & Loss, Standard, set Dates to the required Full year and Columns as Months to show each month of the year. You must use a full year not YTD. To save this as an Excel file go Print, select File, and file type Excel/Lotus spreadsheet then click Print. Save the file as PL.csv in the same directory as your Compiler file. Items with zero value should use "0" not a blank. If you wish to make budget to actual comparison's in your Compiler you should ensure all active accounts are included in your report, from the displayed report go Customize, Advanced, and set Display Rows to Active. If Active Rows are not used or new accounts are added there may be a mismatch between budget and actual data sets. The PL.csv file should be closed when you click Update PL, it is controlled by the Compiler." See https://bizpep.com/budgetbusiness.html for full Help.

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

Q: We would like to create a monthly budget and import it into QB so that we can do budget vs actual comparisons. I am not sure how we do this.

A: With Budget Compiler QuickBooks Excel you can import your current Profit and Loss data from QuickBooks as a PL.csv file to Excel and create budget data and then create a Imp.iff file containing your budget data that can be imported by QuickBooks. See the Help file for details https://bizpep.com/budgetbusiness.html . You can also download and trial the Budget Compiler QuickBooks Excel from https://bizpep.com/budgetbusiness.html .

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

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