Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello there, @obaidasif.
I'm here to share information about your concern in QuickBooks Desktop.
If your client is running a clinic with Beds, you can use a Service Item namely "Bed Daily Rate or Beds Daily. So when you have a patient to invoice for their daily rate, you can quantify by day and provide how much per day.
However, if you're tracking Beds Availablity then you can use Inventory Type Item with the same name for example, and provide each Bed their own Inventory Item name.
To create a new item, here's how:
For more information, see this article: Add, edit, and delete items. It also provides other helpful articles that can help you in the future.
I'm here to help if you have other questions about QuickBooks Desktop. Have a good one.
So let me clarify further, basically there is a small hospital client I have that has 163 beds available and in any given month there are so many days (31 days is the max). So the max capacity is therefore 163 beds x 31 days = 5053 patient days. I have attached the actual amount of units they had in each month per agency below.
What I am trying to accomplish is the rate per month for each revenue and expense account. So in the month of January if the revenue was $900,000, and the total days was 4802 the per patient revenue was $187.42 per day.
The expense accounts would similarly be divided by this 4802 amount as well. Each month would have different patient days figure. An accumulated year end totals would take the sum of days and the sum of revenues/expenses and simply divide for a per unit cost.
Hi there and thank you for the screenshot, obaidasif,
I can clear things out for you. The unit of measure (U/M) in QuickBooks Desktop can only handle one unit of measure for each item. Hence, you're unable to have 2 types of unit.
I've got an article to help you assign a U/M: Use single and multiple units of measure for items. It provides detailed steps on how to use this feature and if ever you need to change the setup.
Keep me posted if you have follow-up questions. I'm always right here to help.
This link does not help, can you please explain in detail how I can set this up?
This is not detailed information, this is a copy and paste of the same article your colleague posted. I need a step by step walk through specifically for my question.
Thanks for actively responding, @obaidasif. I've read your post from the start to make sure I'm able to grasp the details of your concern.
QuickBooks can only determine the total monthly sales based on the total number of days and beds used per month if you have a specific rate per bed, not the other way around as the total number of days varies each month.
Hence, what you're trying to accomplish isn't possible as QuickBooks unable to use the unit of measure to determine your monthly sales. I'd suggest you consult an accountant if you want to use this method to make sure your books are accurate.
As a workaround, I'd recommend you set a specific rate per bed instead. Then, create the service item by following the steps shared by my peer, @JoesemM.
For future reference, you can run the Sales by Item Detail report to know where your business stands. Read through this article: Customize reports in QuickBooks Desktop. It helps you learn about how to use filters to personalize the report according to your business needs.
Feel free to post again if there's something you'd like to ask. I'm always around to help.
Is there anyway we can input days per month and apply this rate to apply to a month? For example, if the patient days rate we set for January were 4,802 and revenue in the month of January was $9,000,000, expenses $500,000 the calculation should be 9000000/4802 = $187.42 revenue/patient days and 5000000/4802= $104.12 expense/patient day.
We are inserting a "days" amount for each of the 12 months separately. Is this possible? If so, please explain in detail how to do this?
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here