cancel
Showing results for 
Search instead for 
Did you mean: 
Pladaus
Level 2

Importing 2021 business fiscal year to QBO, that have WIP started in 2020 that wont be on QBO.

We have had a construction business for a few years and we decided to subscribe to QBO. I am only adding the 2021 fiscal year. With that said, I have 2 properties purchased in 2020, meaning 2 WIP started in the 2020 Fiscal year. In another post I was instructed to start my fiscal year as 1st of January, which makes sense. So, I am setting up all my accounts with opening balance just like my financial institution has on the same date. Where I am confused is how to set up my WIP, I have all those expenses, like offer, purchase, closing cost, utilities, etc for the last 4 month of 2020 that if I AJE I will have to add where the money came from, that will mess up the current accounts.

 

Any help would be appreciated.

Solved
Best answer September 02, 2021

Best Answers
john-pero
Community Champion

Importing 2021 business fiscal year to QBO, that have WIP started in 2020 that wont be on QBO.

When changing accounting software, whether as of a fiscal year close or even mid tax year the important thing to enter as BEGINNING balances are ALL the balances from your Balance Sheet as of that date. This includes bank balances, loan balances, asset values,  etc. The WIP accounts have specific 12/31 balances. That is what you enter since the individual transactions are in last year's books.

 

Example, you have Project Jones House and you incurred $123,456.78 in expenditures that due to the tax rules cannot be deducted from income until house is sold -that as you know is a WIP and despite there being 500 individual transactions during 2020 as of end of last year its balance sheet value as a current asset is $123,456.78 and that is what you enter as a 1/1 beginning balance.

 

Every beginning balance , after posting to its individual account, then posts to a special one time use equity account called Opening Balance Equity.  This, in essence, is the value of your business on the date you begin the new year (or end the old)

 

If you are just now creating the accounts with beginning balances you can and should enter those beginning balances with the beginning dates as prompted when setting them up. If you crested the accounts previously with no beginning balances you can use a Journal Entry to add all the starting balances and the total offset, Debit or credit, goes to OBE.

View solution in original post

2 Comments 2
john-pero
Community Champion

Importing 2021 business fiscal year to QBO, that have WIP started in 2020 that wont be on QBO.

When changing accounting software, whether as of a fiscal year close or even mid tax year the important thing to enter as BEGINNING balances are ALL the balances from your Balance Sheet as of that date. This includes bank balances, loan balances, asset values,  etc. The WIP accounts have specific 12/31 balances. That is what you enter since the individual transactions are in last year's books.

 

Example, you have Project Jones House and you incurred $123,456.78 in expenditures that due to the tax rules cannot be deducted from income until house is sold -that as you know is a WIP and despite there being 500 individual transactions during 2020 as of end of last year its balance sheet value as a current asset is $123,456.78 and that is what you enter as a 1/1 beginning balance.

 

Every beginning balance , after posting to its individual account, then posts to a special one time use equity account called Opening Balance Equity.  This, in essence, is the value of your business on the date you begin the new year (or end the old)

 

If you are just now creating the accounts with beginning balances you can and should enter those beginning balances with the beginning dates as prompted when setting them up. If you crested the accounts previously with no beginning balances you can use a Journal Entry to add all the starting balances and the total offset, Debit or credit, goes to OBE.

Pladaus
Level 2

Importing 2021 business fiscal year to QBO, that have WIP started in 2020 that wont be on QBO.

@john-peroOnce again, thank you for help. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us