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

Project Beginning Balances

Greetings.

 

I am setting up a new set of books for a client that uses projects. I'm planning to enter the balance sheet beginning balances as a JE or added to each individual GL account. But I don't see a place to enter the billed & cost beginning balances for the projects being carried over to Quickbooks.

 

We are Plus subscribers and we also use Tsheets. I understand the hour entries from Tsheets are non-posting anyway, which is why I'm hoping to be able to enter a beginning balance for cost, I just can't find where to do it.

 

For the billed revenue beginning balance, I hope there is a better way than to enter past invoices one by one which will make calculating my financial beginning balances a nightmare.

 

Thank you!

1 Comment 1
MadelynC
Moderator

Project Beginning Balances

I’m glad that you dropped by @klav1.


Let me provide some information on how we can manage project beginning balances in QuickBooks online.


The method for entering balances for customers and vendors depends on when you started using QuickBooks. If you want to keep track of individual sales or bills that make up your projects, you'll want to enter each unpaid invoice and unpaid bill instead of the total balance.


In your customer’s information, you’ll want to set up an opening balance. So every time you create transactions, QuickBooks will track everything. Here’s how:

 

  1. Select the Sales menu, then Customers.
  2. Select the customer’s name, then go to Customer Details.
  3. Hit Edit.
    Capture.PNG
  4. Go to the Payments and Billing, then enter Opening Balance as of date.
  5. Press Save.
    Capture.PNG

Check out this reference to learn more about entering opening balances for customers and vendors. It includes information on what accounts are being impacted.


I've also attached this article about tracking income, costs, and profitability by the project. I’m sure you’ll find it helpful.


Know that I'm only a couple of clicks away if you need anything else. Have a fantastic day!

Need to get in touch?

Contact us