[redox1100]

does anyone know of a commonly used quick books forum for beginners. i am starting a small business and have some technical questions.

Thanks in advance

[littlenumberrobot]

Have you looked at the intuit support site? A lot of QB Proadvisors are on there and answer questions that may not be up front in the help menus.

https://community.intuit.com/

CA CPA - All because of the journey listed below
-----------------------------------------------------------------------
FAR - 53('10), 8/25/12 79 PASSED!
REG - 66('11), 69('12), 12/06/12 77 PASSED!!
BEC - 58('10), 74('12), 01/05/13 77 PASSED!!!
AUD - 43('11), 66('12), 69('13), 74('13) 7/29/13 85 PASSED!!!!!

(Combinations of Roger, Yaeger, Wiley Book, Wiley TB, & NINJA Notes)

Ethics 90%

[littlenumberrobot]

Have you looked at the intuit support site? A lot of QB Proadvisors are on there and answer questions that may not be up front in the help menus.

https://community.intuit.com/

CA CPA - All because of the journey listed below
-----------------------------------------------------------------------
FAR - 53('10), 8/25/12 79 PASSED!
REG - 66('11), 69('12), 12/06/12 77 PASSED!!
BEC - 58('10), 74('12), 01/05/13 77 PASSED!!!
AUD - 43('11), 66('12), 69('13), 74('13) 7/29/13 85 PASSED!!!!!

(Combinations of Roger, Yaeger, Wiley Book, Wiley TB, & NINJA Notes)

Ethics 90%

[musicamor]

What is your question? I am an advanced user of QuickBooks.

Texas CPA - licensed in 2012!!!

[musicamor]

What is your question? I am an advanced user of QuickBooks.

Texas CPA - licensed in 2012!!!

[Nami]

hi, i also used quick book for bank reconciliation.

i seem to get wrong beginning balance.

when you have electronic fund transfer from another account, do you need to add this record or it just automatically go to the journal entries.

how to change category of account? from A.R to expense?

thank you

Illinois CPA 02/15

[Nami]

hi, i also used quick book for bank reconciliation.

i seem to get wrong beginning balance.

when you have electronic fund transfer from another account, do you need to add this record or it just automatically go to the journal entries.

how to change category of account? from A.R to expense?

thank you

Illinois CPA 02/15

[Liss, Master of Coin]

I love QuickBooks, and know it pretty well. Hope I can help.

@Nami

I'm not sure what exactly is causing your beginning balance to be off, but my guess is that something that was already finalized and been reconciled, was accidently changed.

With your previous bank statements nearby. Go to your checking account, “Banking” then “Reconcile”. Toward the bottom of the screen that pops up, select “Undo Last Reconciliation” then follow the instructions to undo it. Compare the beginning balance to your bank statement. If it still doesn't match, keep ‘undoing' until the beginning matches. Then re-reconcile the statement(s); double check everything. You should be able to find it.

As far as EFTs, if they are between 2 of your B/S accounts, use “Transfer Funds” found under “Banking.” Much easier than a journal entry, but a J/E can still be used.

I'm confused on why you'd want to change the Accounts Receivable account to an expense.

If you do mean to change the A/R account on the Chart Of Accounts (or one account type to another), I don't believe it can be done; you'd have to delete or inactivate the account and create a new expense account.

If you mean an invoice was entered as a bill but should have been a check, either pay it or delete the bill and recreate as a check.

CPA (MA, Non-Reporting)

The difference in winning & losing is most often, not quitting - Walt Disney

B - 33, 71, 79!
A - 32, 61, 70, 83!
R - 33, 58, 73, 69, 81!
F - 47, 78! 🙂
After 3 long years, I'm finally DONE!
I could not have done it without NINJA MCQs.

Used: Roger for his Videos, WTB, and NINJA Audio, Notes and Test Bank.

[Liss, Master of Coin]

I love QuickBooks, and know it pretty well. Hope I can help.

@Nami

I'm not sure what exactly is causing your beginning balance to be off, but my guess is that something that was already finalized and been reconciled, was accidently changed.

With your previous bank statements nearby. Go to your checking account, “Banking” then “Reconcile”. Toward the bottom of the screen that pops up, select “Undo Last Reconciliation” then follow the instructions to undo it. Compare the beginning balance to your bank statement. If it still doesn't match, keep ‘undoing' until the beginning matches. Then re-reconcile the statement(s); double check everything. You should be able to find it.

As far as EFTs, if they are between 2 of your B/S accounts, use “Transfer Funds” found under “Banking.” Much easier than a journal entry, but a J/E can still be used.

I'm confused on why you'd want to change the Accounts Receivable account to an expense.

If you do mean to change the A/R account on the Chart Of Accounts (or one account type to another), I don't believe it can be done; you'd have to delete or inactivate the account and create a new expense account.

If you mean an invoice was entered as a bill but should have been a check, either pay it or delete the bill and recreate as a check.

CPA (MA, Non-Reporting)

The difference in winning & losing is most often, not quitting - Walt Disney

B - 33, 71, 79!
A - 32, 61, 70, 83!
R - 33, 58, 73, 69, 81!
F - 47, 78! 🙂
After 3 long years, I'm finally DONE!
I could not have done it without NINJA MCQs.

Used: Roger for his Videos, WTB, and NINJA Audio, Notes and Test Bank.

[Anonymous]

Any QB experts than can help with this? I need to print a P&L that contains for example: June CY, June PY, CY to date, PY to date – all on one report. I can get the first three columns in but can't get the system to add PY to date. I know I could export to excel and combine but is there a way to do this directly in QB? Thanks!

[Anonymous]

Any QB experts than can help with this? I need to print a P&L that contains for example: June CY, June PY, CY to date, PY to date – all on one report. I can get the first three columns in but can't get the system to add PY to date. I know I could export to excel and combine but is there a way to do this directly in QB? Thanks!

[KiwiCPA]

@ Nami

I can help with the bank rec – maybe.

When you go to reports and pull up your prior period bank recs you have two options. One is a PDF, which is the original or an excel, which is the original plus any changes that have made. By this i mean – after you reconciled you account a transaction was entered with a date prior to the end date of the bank rec. This will change all bank reconciliations from the date of the transaction to your last bank rec. By comparing the PDF and excel copy, you can tell if changes have been made and maybe pinpoint the date.

Prior to undoing any prior bank rec I would compare the ending statement balance with the cleared balance.

For transfers the need to be recorded – use the menu at the top of the screen – banking – transfer funds and select the two relevant accounts. If you are downloading the transaction from the web you may need to click on the transaction & make sure it hits the correct accounts.

To change an account type – again use the menu – lists – chart of accounts. You can the right click on the account and edit the account properties.

I used QB 2009 to answer this, but have access to and use QB 2008 – 2014 plus QB online.

Reg 82; FAR 75; AUD 91; BEC 11/9/13; result due - 11/22/13

[KiwiCPA]

@ Nami

I can help with the bank rec – maybe.

When you go to reports and pull up your prior period bank recs you have two options. One is a PDF, which is the original or an excel, which is the original plus any changes that have made. By this i mean – after you reconciled you account a transaction was entered with a date prior to the end date of the bank rec. This will change all bank reconciliations from the date of the transaction to your last bank rec. By comparing the PDF and excel copy, you can tell if changes have been made and maybe pinpoint the date.

Prior to undoing any prior bank rec I would compare the ending statement balance with the cleared balance.

For transfers the need to be recorded – use the menu at the top of the screen – banking – transfer funds and select the two relevant accounts. If you are downloading the transaction from the web you may need to click on the transaction & make sure it hits the correct accounts.

To change an account type – again use the menu – lists – chart of accounts. You can the right click on the account and edit the account properties.

I used QB 2009 to answer this, but have access to and use QB 2008 – 2014 plus QB online.

Reg 82; FAR 75; AUD 91; BEC 11/9/13; result due - 11/22/13

[littlenumberrobot]

@CPA_Driven – I just tried and I cannot do what you need either. Looks like excel is your best bet for that one.

CA CPA - All because of the journey listed below
-----------------------------------------------------------------------
FAR - 53('10), 8/25/12 79 PASSED!
REG - 66('11), 69('12), 12/06/12 77 PASSED!!
BEC - 58('10), 74('12), 01/05/13 77 PASSED!!!
AUD - 43('11), 66('12), 69('13), 74('13) 7/29/13 85 PASSED!!!!!

(Combinations of Roger, Yaeger, Wiley Book, Wiley TB, & NINJA Notes)

Ethics 90%

[littlenumberrobot]

@CPA_Driven – I just tried and I cannot do what you need either. Looks like excel is your best bet for that one.

CA CPA - All because of the journey listed below
-----------------------------------------------------------------------
FAR - 53('10), 8/25/12 79 PASSED!
REG - 66('11), 69('12), 12/06/12 77 PASSED!!
BEC - 58('10), 74('12), 01/05/13 77 PASSED!!!
AUD - 43('11), 66('12), 69('13), 74('13) 7/29/13 85 PASSED!!!!!

(Combinations of Roger, Yaeger, Wiley Book, Wiley TB, & NINJA Notes)

Ethics 90%

[Author]

Replies