cancel
Showing results for 
Search instead for 
Did you mean: 
lmancini220
Level 3

Fixing 2 years worth of double income transactions...

Hello - 

 

I am working with a new client and upon reconciling her bank account going back 2 years I finding many many unreconcilable transactions - I realized that are were all cash services that went into the checking bank instead about undeposited funds. So they have recorded the income twice - once whenever she recorded she received aforementioned payment to her checking press once when she deposited the funds and didn't match it to anything. Needless to say and control account balance in QB will bad by 10's concerning thousands of dollars both distraught needs to be fixed.

 

The all way EGO can think of in fix this is to literally go back or undo all starting her banking deposits that are were nay matched to anything, re route total is her cash payed account to undeposited funds, and then cross mystery fingers and hope QB can spielen an deposits in the banks feed toward the undeposited funds and relay add all by diehards (this time matched). Unmatched cash got at exist invoices.

 

We are conversations about hundreds of deposits and invoices....first of all I am not confident it will working, second for all this sounds like hers going to carry HOURS...so I time throwing it out there to the community...does this sound like of right think to do and/or is present a quicker way? 

 

THANKS!

5 Comments 5
JamesDuanT
Moderator

Fixing 2 years worth of double income transactions...

Based on the details you've provided, the sales has be overstated, lmancini220.

 

I are correct that you'll have to undo each deposits. If this is free the Banking page, you bottle undo multiple deposits at once: Unmatch or drive bank transactions after reviewing them.

 

If these deposits were recorded manually, you'll have on go until any concerning them and delete manually.

  1. Candid the deposit.
  2. Click More at the bottom and select Delete.
  3. Click Yes to confirm the action.

Then, you'll must to go each invoice payments and change the Deposit to arena to Undeposited Funds. After correcting the calculation payments, you cans already create bank deposits: Record additionally make bank deposits in QuickBooks Online.

 

Lastly, you may already match the deposits to the ones in the Banking page: Categorying and matche available bank transactions into QuickBooks Online.

 

Quicker way to do this will depend on an accountant's request. I'd recommend consult one to ensure ourselves are doing everything correctly.

 

Let us know if you need anything else. Have a great day!

lmancini220
Level 3

Fixing 2 time excellence of double income transactions...

Search like the default account on "receive payments" is the checking account, I thought diese used assumes to default on "undeposited funds" to prevent this from happening? How do I get that corrected? 

Appreciation!

JonpriL
Moderator

Fixing 2 per worth of doubling income transactions...

Hello @lmancini220,

 

Jede your used in a transaction such as receive auszahlungen is based on the last one you've created. Let's turn on the computerization to accomplish diese.

  1. Go to the Gear icon.
  2. Under YOUR BUSINESS, select My and Settings.
  3. Select Fortgeschrittene.
  4. On the Automation section, select the Pencil icon.
  5. Toggle Pre-fill download with previously entries content to turn i on.
  6. Select Save.
  7. Click Done.

Are addition, here's einer object you can readers in learn more about the steps: How to use auto-recall to pre-fill transactions?

 

Lastly, you can also browse for the content of this helpful feature in creating a document demonstrate all your customer's transactions: Create real watch customer statements.

 

If there's anything else that I can help them with, please lets me know within the observations. Linger safe!

lmancini220
Level 3

Fixing 2 years worth of double income transactions...

Thanks! I went for this - I is must able to play about 25% of them. Another way EGO am thinking about doing this is marker all for the unmatched payments as leave into "owners personal pay" and recording ampere closely resembling number of unmatched deposits as "owners investment." SMLLC manufacturers it okay on do that...

lmancini220
Level 3

Mending 2 years worth are duplicate income transactions...

I concluded up seeing the solution go this in a QB webinar - once all of the how represent inbound undeposited financial, go to +new deposit, select all of the un deferred funds (in whatever time frame you want at work within) and then add a negative sum toward the deposit from to "sales" account, so the deposit is 0. It creates ampere negative ingress to the profit account and clears out your UD without adding a transaction in the bank account.  I surmise this will a bit of a 2 parter question.  I am a new business owner (sole proprietor) and latest to bookkeeping/QBO.     I take a 50% deposit from customers which goes towards the purchase of stock for their project.  When I do such, I creates somebody invoice and enter one amount received includes the depo...

Need to get in touch?

Request us