cancel
Showing results for 
Search instead for 
Did you mean: 
SheridanStotts
Level 1

Vendor Bill Breakdown by Percentage

I am using QuickBooks Desktop. We breakdown some of our vendor invoices by percentage for different divisions within our company. An example would be a bill from an advertising company. We will breakdown the invoice amount and allocate it to each division.

Let's say the invoice is for $100.00

Div1 Commercial will get 45% $45.00

Div2 Residential will get 5% $5.00

Div3 Controls will get 25% $25.00

Div4 Service will get 25% $25.00

Is there a way to set it up when I enter a bill for a specific vendor that it will auto fill the set percentages when I enter the bill amount? Right now I'm having to do this in Excel.  

 

1 Comment 1
JoesemM
Moderator

Vendor Bill Breakdown by Percentage

Good day, @SheridanStotts.

 

We can create a create a memorized transaction per Vendor. This way, you can manage repeating transactions and get a reminder every time it's due to save time. Here's how:

 

  1. Click the Edit menu then select Memorized Bill.
  2. Enter a Name for the Bill.
  3. Choose how you want QuickBooks to handle it.
    • Add to my Reminders List.
    • Do Not Remind Me.
    • Automate Transaction Entry.

   4. Enter other information, then click OK.

   5. Select Save & Close or Save & Next.

 

Let's turn on first the add by group to use this feature. 

 

Here's how:

  1. Go to Lists, select Memorized transaction List.
  2. Click the small drop-down arrow under Memorized Transaction located in the lower part.
  3. Choose New Group, then put a name and tap OK.

Once you create a bill , you'll just have to click the Memorized transaction.

 

See this article for detailed steps: Create, edit, or delete memorized transactions.

 

I'll add this article for future reference: Accounts Payable workflows in QuickBooks Desktop.

 

Keep me posted if you have any other concerns. I'm always here to assist you further and provide more insights. Have a nice day!

Need to get in touch?

Contact us