Cleaning up QB - Years of unapplied payments

Hello there, KimRussel.

Thank you for reaching out to us here in the Community. I'm here to provide some suggestions about making the changes from closed books.

In QuickBooks Desktop, you're able to create a closing date password to restrict accessing data from the prior accounting period. To make changes, you must know the password and should have appropriate permissions to make the changes.

For more insights, I'm adding the article I recommend on this:

Close your books in QuickBooks Desktop.

You can also try to write off customer and vendor balances by creating General Journal Entry. For the detailed steps, please visit this article:

Write off customer and vendor balances.

Please feel free to get in touch with me here for any additional questions. The Community always has your back.

---

---

@AlcaeusF wrote:

Hello there, KimRussel.

 

Thank you for reaching out to us here in the Community. I'm here to provide some suggestions about making the changes from closed books.

 

In QuickBooks Desktop, you're able to create a closing date password to restrict accessing data from the prior accounting period. To make changes, you must know the password and should have appropriate permissions to make the changes.

 

For more insights, I'm adding the article I recommend on this:

 

Close your books in QuickBooks Desktop.

 

You can also try to write off customer and vendor balances by creating General Journal Entry. For the detailed steps, please visit this article:

 

Write off customer and vendor balances.

 

Please feel free to get in touch with me here for any additional questions. The Community always has your back.

---

@AlcaeusF wrote:

Hello there, KimRussel.

 

Thank you for reaching out to us here in the Community. I'm here to provide some suggestions about making the changes from closed books.

 

In QuickBooks Desktop, you're able to create a closing date password to restrict accessing data from the prior accounting period. To make changes, you must know the password and should have appropriate permissions to make the changes.

 

For more insights, I'm adding the article I recommend on this:

 

Close your books in QuickBooks Desktop.

 

You can also try to write off customer and vendor balances by creating General Journal Entry. For the detailed steps, please visit this article:

 

Write off customer and vendor balances.

 

Please feel free to get in touch with me here for any additional questions. The Community always has your back.

---

---

@AlcaeusF wrote:

Hello there, KimRussel.

 

Thank you for reaching out to us here in the Community. I'm here to provide some suggestions about making the changes from closed books.

 

In QuickBooks Desktop, you're able to create a closing date password to restrict accessing data from the prior accounting period. To make changes, you must know the password and should have appropriate permissions to make the changes.

 

For more insights, I'm adding the article I recommend on this:

 

Close your books in QuickBooks Desktop.

 

You can also try to write off customer and vendor balances by creating General Journal Entry. For the detailed steps, please visit this article:

 

Write off customer and vendor balances.

 

Please feel free to get in touch with me here for any additional questions. The Community always has your back.

---

---

@AlcaeusF wrote:

Hello there, KimRussel.

 

Thank you for reaching out to us here in the Community. I'm here to provide some suggestions about making the changes from closed books.

 

In QuickBooks Desktop, you're able to create a closing date password to restrict accessing data from the prior accounting period. To make changes, you must know the password and should have appropriate permissions to make the changes.

 

For more insights, I'm adding the article I recommend on this:

 

Close your books in QuickBooks Desktop.

 

You can also try to write off customer and vendor balances by creating General Journal Entry. For the detailed steps, please visit this article:

 

Write off customer and vendor balances.

 

Please feel free to get in touch with me here for any additional questions. The Community always has your back.

---

I appreciate the screenshot you've provided, luther253.

Let me help you go over to your QuickBooks Online account and have those transactions matched and reconciled.

As referenced by my peer above, you must know the password to match the unapplied transactions and deposits in QuickBooks Online. If you don't remember the password for the closed books, you can change the closing date password.

Here's how:

1. Select the Gear icon at the upper right corner.
2. Under Your Company, select Account and Settings.
3. From the left menu, select Advanced.
4. In the Accounting section, select the Pencil icon.
5. Enter a new password in the Closing date field.
6. Select Done.

After that, you can match the unapplied transactions and deposits. Here's a helpful article that you might find helpful: Assign, categorize, edit, and add your downloaded banking transactions.

Also, these articles are good references:

• Reconcile hub.
• Unapplied cash payment income on your profit and loss.
• How to link a deposit to an invoice.
• How to record a customer payment.

For additional help, you can reach out to our QuickBooks Online Support. To reach us, please follow these steps:

1. Sign in to your QuickBooks Online Company.
2. Click (?) Help at the upper right corner.
3. Select Contact US on the pop-up.
4. Enter a brief description of your concern then hit Continue.
5. Click Get a callback.
6. Enter your contact information.
7. Select Call me.

If you need more help matching and reconciling your transactions in QuickBooks, please let me know. I'll be around to help. Have a good one.

---

@luther253 wrote:

---

@AlcaeusF wrote:

Hello there, KimRussel.

 

Thank you for reaching out to us here in the Community. I'm here to provide some suggestions about making the changes from closed books.

 

In QuickBooks Desktop, you're able to create a closing date password to restrict accessing data from the prior accounting period. To make changes, you must know the password and should have appropriate permissions to make the changes.

 

For more insights, I'm adding the article I recommend on this:

 

Close your books in QuickBooks Desktop.

 

You can also try to write off customer and vendor balances by creating General Journal Entry. For the detailed steps, please visit this article:

 

Write off customer and vendor balances.

 

Please feel free to get in touch with me here for any additional questions. The Community always has your back.

---

---

@AlcaeusF wrote:

Hello there, KimRussel.

 

Thank you for reaching out to us here in the Community. I'm here to provide some suggestions about making the changes from closed books.

 

In QuickBooks Desktop, you're able to create a closing date password to restrict accessing data from the prior accounting period. To make changes, you must know the password and should have appropriate permissions to make the changes.

 

For more insights, I'm adding the article I recommend on this:

 

Close your books in QuickBooks Desktop.

 

You can also try to write off customer and vendor balances by creating General Journal Entry. For the detailed steps, please visit this article:

 

Write off customer and vendor balances.

 

Please feel free to get in touch with me here for any additional questions. The Community always has your back.

---

---

@AlcaeusF wrote:

Hello there, KimRussel.

 

Thank you for reaching out to us here in the Community. I'm here to provide some suggestions about making the changes from closed books.

 

In QuickBooks Desktop, you're able to create a closing date password to restrict accessing data from the prior accounting period. To make changes, you must know the password and should have appropriate permissions to make the changes.

 

For more insights, I'm adding the article I recommend on this:

 

Close your books in QuickBooks Desktop.

 

You can also try to write off customer and vendor balances by creating General Journal Entry. For the detailed steps, please visit this article:

 

Write off customer and vendor balances.

 

Please feel free to get in touch with me here for any additional questions. The Community always has your back.

---

 

---

Thanks for getting back to us, luther253.

You can run the account register and compare it to your bank statements. Once you've identified the missing transactions, simply download them into QuickBooks Online (QBO). I'm here to guide you on this.

There are two options to bring them in.

First is to connect your bank account and manually add the bank transactions.

1. Choose Banking, on the left pane and click the Add Account button.
2. Search and select your financial institution from the list.
3. Enter your Login credentials for the financial institution's website and hit Continue.
4. Complete the security verification steps your financial institution requires and select Securely connect.
5. Click the bank emblem for the account you want to connect.
6. Choose the Account type drop-down menu to choose either a Bank or Credit Card account.
7. If you haven't already created the account, you can select +Add new to create a new account.
8. Lastly, click Connect.

Then, you can now assign, categorize, edit, and add your downloaded banking transactions. 
 

Second is to manually upload these transactions using a WebConnect file.

Once the account register and bank balance have matched, you can now start reconciling.

Let me know on how it goes. I'll be here if you need additional support about the bank connection in QuickBooks Online or if you need anything else.

---

@PreciousB wrote:

Thanks for getting back to us, luther253.

 

You can run the account register and compare it to your bank statements. Once you've identified the missing transactions, simply download them into QuickBooks Online (QBO). I'm here to guide you on this.

There are two options to bring them in.

 

First is to connect your bank account and manually add the bank transactions.

1. Choose Banking, on the left pane.
2. On the Banking page, select Add Account.
3. Search and select your financial institution from the list.
4. Enter your Login credentials for the financial institution's website and select Continue.
5. Complete the security verification steps your financial institution requires and select Securely connect.
6. Hit the bank emblem for the account you want to connect.
7. Choose the Account type drop-down menu to choose either a Bank or Credit Card account.
8. If you haven't already created the account, you can select +Add new to create a new account.
9. Select Connect.

Here's a relevant article for the detailed steps: How to add and connect bank and credit card accounts.
 

Once done, you can now assign, categorize, edit, and add your downloaded banking transactions. 
 

Second is to manually upload these transactions using a WebConnect file.

 

Once the account register and bank balance have matched, you can start reconciling.

 

Let me know on how it goes. I'll be here if you need additional support about bank connection in QuickBooks Online or if you need anything else.

---

---

@PreciousB wrote:

Thanks for getting back to us, luther253.

 

You can run the account register and compare it to your bank statements. Once you've identified the missing transactions, simply download them into QuickBooks Online (QBO). I'm here to guide you on this.

There are two options to bring them in.

 

First is to connect your bank account and manually add the bank transactions.

1. Choose Banking, on the left pane.
2. On the Banking page, select Add Account.
3. Search and select your financial institution from the list.
4. Enter your Login credentials for the financial institution's website and select Continue.
5. Complete the security verification steps your financial institution requires and select Securely connect.
6. Hit the bank emblem for the account you want to connect.
7. Choose the Account type drop-down menu to choose either a Bank or Credit Card account.
8. If you haven't already created the account, you can select +Add new to create a new account.
9. Select Connect.

Here's a relevant article for the detailed steps: How to add and connect bank and credit card accounts.
 

Once done, you can now assign, categorize, edit, and add your downloaded banking transactions. 
 

Second is to manually upload these transactions using a WebConnect file.

 

Once the account register and bank balance have matched, you can start reconciling.

 

Let me know on how it goes. I'll be here if you need additional support about bank connection in QuickBooks Online or if you need anything else.

---

---

@PreciousB wrote:

Thanks for getting back to us, luther253.

 

You can run the account register and compare it to your bank statements. Once you've identified the missing transactions, simply download them into QuickBooks Online (QBO). I'm here to guide you on this.

There are two options to bring them in.

 

First is to connect your bank account and manually add the bank transactions.

1. Choose Banking, on the left pane.
2. On the Banking page, select Add Account.
3. Search and select your financial institution from the list.
4. Enter your Login credentials for the financial institution's website and select Continue.
5. Complete the security verification steps your financial institution requires and select Securely connect.
6. Hit the bank emblem for the account you want to connect.
7. Choose the Account type drop-down menu to choose either a Bank or Credit Card account.
8. If you haven't already created the account, you can select +Add new to create a new account.
9. Select Connect.

Here's a relevant article for the detailed steps: How to add and connect bank and credit card accounts.
 

Once done, you can now assign, categorize, edit, and add your downloaded banking transactions. 
 

Second is to manually upload these transactions using a WebConnect file.

 

Once the account register and bank balance have matched, you can start reconciling.

 

Let me know on how it goes. I'll be here if you need additional support about bank connection in QuickBooks Online or if you need anything else.

---

The following steps will help you resolve Unapplied cash payment income on your Profit and Loss report.

Step 1: Run the Open Invoices report

To run the open invoices report:

    From the left menu, select Reports.

    In the Find report by name field, enter Open Invoices.

    Set the report period, then select Run report.

    In the Transaction Type column, locate a transaction listed as a Payment.

If that Payment  transaction matches an open invoice, go to Step 2. If you don’t see a matching open invoice, go directly to Step 3.

Step 2: If the Payment transaction matches an open invoice

If that payment matches an open invoice, follow these steps.

    Select the Payment date to open.

    Under Outstanding Transactions, check the open invoice.

    Select Save and close.

Step 3: If the Payment transaction doesn’t match an open invoice

If the payment doesn’t match an open invoice, you’ll need to create the transaction. Follow these steps:

    Select the Plus icon (+) on the Toolbar.

    Under Customers, select Invoice.

    Fill out the form with the same customer, amount and date as the payment.

    Select Save and send.

    Go back to the Open Invoices report.

    Find the unapplied payment, then select the date to open.

    Under Outstanding Transactions, check the open invoice.

    Select Save and send.

    Check your Open invoices report to see if there are any more transactions listed as a Payment. If there are, repeat step 2 for each one.

Now run your Profit and Loss report again. You should no longer see the Unapplied cash payment income.

Regards,

Adrian

Hosted QuickBooks Consultant

Good to have you back, luther253.

Let's match those transactions first. Then, add those that need to be added in QuickBook Online.

Once done, you can reconcile them in a yearly basis. You can find the detailed steps on how to reconcile accounts in this article.

Keep us posted for additional questions. We're here to help you out.

I'm here to ease your confusion, Luther253.

You can either manually enter the missing transactions or import them using the WebConnect feature. Although, you still have to check with your bank if they can provide you the transactions from January 2016 to May 23, 2016. 

Once all transactions are entered/imported, you can go through with the reconciliation process. Just refer to the article provided by GlinetteC. 

Please know we're just here if you have other concerns. Have a good one!