Questions & Answers

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: Once registered, this software can be used for many domains on different servers???

A: Yes, Licensing is by user not domain. With a single user license your can use it for as many sites/domains as you like as long as there is only 1 person using the software that builds the sitemap.

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

Q: I'd like to trial Shift Scheduler Continuous Excel 30. I'm from a library and we are looking for rostering software to auto generate a roster for our service desks.

A: You can download this software free of charge for evaluation from https://bizpep.com/shiftscheduler.html

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

<< < Page 51 52 53 54 55 56 57 58 59 60 > >>