This discussion has been closed by the moderator.
how to enter vendor beginning balance
11/9/08 7:43 AM, Viewed by asker 11/12/08 9:21 PM
Total Views: 902
Total Views: 902
how to enter vendor beginning balance
Solved!Best Answer - Chosen by the Community
Rating + 11
Helpful Answer
11/9/08 10:54 AM
I would not enter beginning balances in any of those windows when setting up accounts, vendors, customers, or items.
This is what I do when I am starting a new file with existing data:
If you have an accurate trial balance from a previous month/year, enter it as one journal entry. (Do not enter any opening balances when setting up new accounts in the COA.)
For the Checking account, enter only the reconciled bank statement amount in that journal entry, but do not enter any a/r or a/p amounts.
Let the variance hit Opening Balance Equity.
Then, enter any outstanding checks/deposits and hit OBE. (use the write checks/make deposits windows)
Then, enter Unpaid Bills and Open Invoices, one at a time with the vendor/customer name. . offsetting OBE. (use the enter bills/create invoices windows - you will have to set up an item which points to OBE for the invoices)
When you complete these three steps, your OBE should be zero.
This will give you the detail of outstanding checks/deposits so that you can reconcile next month's bank statement.
This, also, will give you an accurate A/P and A/R with enough detail to move forward in paying bills and receiving payments.
If this answers your question, please mark this post as 'solved'. Otherwise, submit a comment for clarification.
Laura D
See my profile at:
http://proadvisor.intuit.com/referral/proadvisor_profile.jsp?id=YQ88CA%2BS0H5c1ImS11E9oQ%3D%3D
This is what I do when I am starting a new file with existing data:
If you have an accurate trial balance from a previous month/year, enter it as one journal entry. (Do not enter any opening balances when setting up new accounts in the COA.)
For the Checking account, enter only the reconciled bank statement amount in that journal entry, but do not enter any a/r or a/p amounts.
Let the variance hit Opening Balance Equity.
Then, enter any outstanding checks/deposits and hit OBE. (use the write checks/make deposits windows)
Then, enter Unpaid Bills and Open Invoices, one at a time with the vendor/customer name. . offsetting OBE. (use the enter bills/create invoices windows - you will have to set up an item which points to OBE for the invoices)
When you complete these three steps, your OBE should be zero.
This will give you the detail of outstanding checks/deposits so that you can reconcile next month's bank statement.
This, also, will give you an accurate A/P and A/R with enough detail to move forward in paying bills and receiving payments.
If this answers your question, please mark this post as 'solved'. Otherwise, submit a comment for clarification.
Laura D
See my profile at:
http://proadvisor.intuit.com/referral/proadvisor_profile.jsp?id=YQ88CA%2BS0H5c1ImS11E9oQ%3D%3D
All Replies: Answers (3)
Comments (1)
Rating + 5
Answer
11/9/08 9:15 AM
When you enter a "New vendor in QB 08, it gives you the option of entering opening balances and dates. It only allows a lum sum amount. Let me know if this helps or if you need directions.
Rating + 11
Solved!
11/9/08 10:54 AM
I would not enter beginning balances in any of those windows when setting up accounts, vendors, customers, or items.
This is what I do when I am starting a new file with existing data:
If you have an accurate trial balance from a previous month/year, enter it as one journal entry. (Do not enter any opening balances when setting up new accounts in the COA.)
For the Checking account, enter only the reconciled bank statement amount in that journal entry, but do not enter any a/r or a/p amounts.
Let the variance hit Opening Balance Equity.
Then, enter any outstanding checks/deposits and hit OBE. (use the write checks/make deposits windows)
Then, enter Unpaid Bills and Open Invoices, one at a time with the vendor/customer name. . offsetting OBE. (use the enter bills/create invoices windows - you will have to set up an item which points to OBE for the invoices)
When you complete these three steps, your OBE should be zero.
This will give you the detail of outstanding checks/deposits so that you can reconcile next month's bank statement.
This, also, will give you an accurate A/P and A/R with enough detail to move forward in paying bills and receiving payments.
If this answers your question, please mark this post as 'solved'. Otherwise, submit a comment for clarification.
Laura D
See my profile at:
http://proadvisor.intuit.com/referral/proadvisor_profile.jsp?id=YQ88CA%2BS0H5c1ImS11E9oQ%3D%3D
This is what I do when I am starting a new file with existing data:
If you have an accurate trial balance from a previous month/year, enter it as one journal entry. (Do not enter any opening balances when setting up new accounts in the COA.)
For the Checking account, enter only the reconciled bank statement amount in that journal entry, but do not enter any a/r or a/p amounts.
Let the variance hit Opening Balance Equity.
Then, enter any outstanding checks/deposits and hit OBE. (use the write checks/make deposits windows)
Then, enter Unpaid Bills and Open Invoices, one at a time with the vendor/customer name. . offsetting OBE. (use the enter bills/create invoices windows - you will have to set up an item which points to OBE for the invoices)
When you complete these three steps, your OBE should be zero.
This will give you the detail of outstanding checks/deposits so that you can reconcile next month's bank statement.
This, also, will give you an accurate A/P and A/R with enough detail to move forward in paying bills and receiving payments.
If this answers your question, please mark this post as 'solved'. Otherwise, submit a comment for clarification.
Laura D
See my profile at:
http://proadvisor.intuit.com/referral/proadvisor_profile.jsp?id=YQ88CA%2BS0H5c1ImS11E9oQ%3D%3D
Rating + 5
Answer
11/10/08 3:39 AM
When viewing a journal entry, or any transaction, ctl-y will give you a printable report.
I like to customize mine by dragging/dropping the memo column and eliminating the columns I don't need. Then, print it.
Unfortunately, you can't memorize the customization of this report.
If this answers your question, please mark this post as 'solved'. Otherwise, submit a comment for clarification.
Laura D
See my profile at:
http://proadvisor.intuit.com/referral/proadvisor_profile.jsp?id=YQ88CA%2BS0H5c1ImS11E9oQ%3D%3D
I like to customize mine by dragging/dropping the memo column and eliminating the columns I don't need. Then, print it.
Unfortunately, you can't memorize the customization of this report.
If this answers your question, please mark this post as 'solved'. Otherwise, submit a comment for clarification.
Laura D
See my profile at:
http://proadvisor.intuit.com/referral/proadvisor_profile.jsp?id=YQ88CA%2BS0H5c1ImS11E9oQ%3D%3D
Comment