Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Reply to message

View discussion in a popup

Replying to:
HAI1670
Level 1

Reply to message

add account/bank type "Sweep Credit" and "Sweep Debit"

 

go to your bank online statements find options for custom reports find a report with the Sweep data included, and export as CSV/Excel file. Sort columns so that the Sweep Credits, debits, and sweep interest are all sorted together and auto sum those amounts (SW CR. SW Dbt, SW Int). 

 

1. add transfer (from CK to SW Debit) this figure is the SW Debit total from the above data sort/sum.

2. add transfer (from SW Credit to CK) this figure is the SW Credit total from the above data sort/sum. NOTE: when you do this for the 2nd/ongoing months this figure will be "stepped over" from the previous month and a "new" transfer will NOT be entered, just step over/replace this figure. 

 

go to the bank rec screen for the checking acct with sweep built in, enter bank statement being and end balance and the Sweep interest figure from the sum/data above for SW Int. 

 

once into the rec screen you will find the #1 above on the checks/pmt side/listings, click it. on the deposit/credit side/listing you will find the #2 from above, click it

these clicked/selected with all your other reg banking items should allow you to reconcile your statement (remember the Sw interest is in the main rec screen).

 

after the rec is completed:

add a NEW transfer (SW Debit to Sw Credit) this is the #1 figure from above)

add a NEW transfer (Sw Credit to CK) this is the LAST SW DEBIT transaction found on the statement you just rec. 

these two transfers should place both the sweep cash accounts back to zero. and will be ready for the next months rec.

see if this makes sense and let me know. 

Need to get in touch?

Contact us