Bank Reconciled Debits & Credits, "Month!" Cleared in?

Every receipt and disbursement that clears through a bank reconciliation shows up in the registers with tick mark.

Every "Invoice" Received pmt shows up on invoice "paid."

Every "Bill" Pay-Bill shows up on the bill "paid."

For Bank Reconciled transactions IS there a report, somewhere that would show the "month" the item was "Cleared"-IN", not just that is was "cleared"

Many times companies no not use "hide" in the bank reconciliation when performing a reconciliation for a specific date ENDED. Thus, if they were reconciling "Dec2016" yes any pre=Dec 2016 items cleared IN Dec would be ok (they were O/S in Nov2016)

BUT!! without "hide" they may have a {Dec-clearing-item) with an incorrect QBooks date of POST 12-31-16

The bank reconciliation WORKS, it doesn't care.

Try to re-run that Dec 2016 Bank Reconciliation at a later date, IT WILL be WRONG! because prior run reconciliations tells it to only look for QBooks transactions before that date ended.

I currently have access to Customer & Vendor QBooks (both my clients)

Vendor Pmt Check $7,824.31, dated 10-5-16, clears that Bank Rec in October

I'm still searching for THAT receive payment in Customer Receive Pmt

The bills paid, $7,824.41 do show up in "a" receive payment & Deposit, the problem is the Deposit is ONE payment $22,638.96 from a TOTALLY different customer than the vendor paying $7,824.31 :(

IF (without running numerous) prior bank reconciliations to see the $7,824.31 clearing I can't just SEE on a report which month the transaction cleared

In Bank reconciliations there is a trick mark "cleared" just be nice in the column was [cleared-12-31-16, 1-31-17 or what ever the reconciliation ending date is 

Answer

"For Bank Reconciled transactions IS there a report, somewhere that would show the "month" the item was "Cleared"-IN", not just that is was "cleared""

The reconciliation is done to an Ending balance and date that were entered in the first screen; that is the reference for the Reconciliation. You can run the Reconciliation reports "as they were" at that time (as pdf), and the top left is the Original Date, as well.

The "Hide Transactions After The Statement End Date" is just to reduce the length of the list you need to scroll through while you work. It doesn't change the Reconciliation; it changes your View. If you are working three months back, you might not need to see the later activity. Or, you need to Reveal that because something is dated later than the Statement Date, such as a Statement ends the 15th but there is a check you originally dated the 17th, and the payee presented it to the bank and made the cutoff of the 15th; or a Deposit you made after 4pm and dated it for Monday, but the business teller went ahead and deposited it with Friday's date and it made the cut off.

"Try to re-run that Dec 2016 Bank Reconciliation at a later date, IT WILL be WRONG! because prior run reconciliations tells it to only look for QBooks transactions before that date ended."

I don't understand this sentence out of context to the function; are you running a report or actually doing "re-run" the Reconciliation tool?

"Vendor Pmt Check $7,824.31, dated 10-5-16, clears that Bank Rec in October

I'm still searching for THAT receive payment in Customer Receive Pmt"

Vendor Payments don't directly relate to Customer Payments, though. You might have entered something billable to the customer, on that purchase, but when and if you invoiced it, and when or if the customer paid, and when and if you paid the vendor, are not linked to each other.

"The bills paid, $7,824.41 do show up in "a" receive payment & Deposit,"

Did you mean to describe that you see where you Charged the customer what you incurred, so that means you can follow to the Payment and Deposit of the customer's funds? Do you use Billable transaction details for this type of activity? If so, you can follow where you incurred something and where you charged it back, but again, the AP payment is against the AP activity; the AR payment is against the AR activity. The AP and the AR only related by the Expense and the Income (the item, typically, that was used) and not any Payment against AR or AP.

"the problem is the Deposit is ONE payment $22,638.96 from a TOTALLY different customer than the vendor paying $7,824.31 :( "

Right; those are not comparable perspectives, as I noted.

"IF (without running numerous) prior bank reconciliations to see the $7,824.31 clearing I can't just SEE on a report which month the transaction cleared"

You have lots of perspectives to see the Customer activity, and lots to see the Vendor Activity, and lots to see the Banking. The vendor and the customer Banking activity don't relate directly.

"In Bank reconciliations there is a trick mark "cleared" just be nice in the column was [cleared-12-31-16, 1-31-17 or what ever the reconciliation ending date is "

Run the reconciliation reports to see these Banking activities.
Was this answer helpful? Yes No
Original
qbteachmt , qbteachmt(at)yahoo(dot)com
AllStar
4 additional answers

No answers have been posted

More Actions

People come to Accountants Community for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach:

Do you still have a question?

Ask your question to the community. Most questions get a response in about a day.

Post your question to the community