cancel
Showing results for 
Search instead for 
Did you mean: 
Frequent Contributor *

fiscal adjustmetns

I recently converted data from SAGE to QuickBooks... When I go into Pay Bills (vendor tab)- I have ancient Fiscal Adjustments for 'bills' to a Dummy Vendor.  I cant delete them, or adjust them... what are they and how do I get them to not show up so I can pay invoices without scrolling through hundreds of fake bills?

I am attaching a screen shot of my Pay Bill screen and the first 'Bill' to the Dummy Vendor

18 Comments
QuickBooks Team

Re: fiscal adjustmetns

Hello there, @clfp.

 

I appreciate you reaching out to the Community and providing a screenshot. I can help you remove the fake bills.

 

On the Pay Bills window, you have the option to filter the bills showing by selecting a specific date. You can use that as an option to lessen the list of open bills.

 

 

To remove them permanently, you can go to the Dummy Vendor profile and delete the transactions one by one.

  1. Click Vendors.
  2. Choose Vendor Center.
  3. Select the vendor's name.
  4. Go to the Transactions tab.
  5. Open the bills and delete them.

 

That should save your time scrolling through the Pay Bills window, gb786.

 

Keep me posted if you have additional questions about paying bills. I'm still here to help you further. Just add a comment below or mention my name. Have a good one.

Frequent Contributor *

Re: fiscal adjustmetns

I appreciate your answer, but I already tried deleting these 'bills' and they just increase my payables - and they still show after filtering by due date, they were 'due' back in 2015-2018 before.JPGafter.JPG

Community Contributor *

Re: fiscal adjustmetns

Did you ever find a solution to this problem?  I recently converted from Sage to Quickbooks also, and have the same problem.  I would love some advice on how to correct!

QuickBooks Team

Re: fiscal adjustmetns

Thanks for joining the thread, @mcclin.

 

Allow me to step in and provide a little information about the bills to a dummy vendor.

 

When migrating from Sage to QuickBooks, all of the transactions from Sage will be transferred to QuickBooks. The possible reason why you can't delete the bills from dummy vendor is that the amount is positive amounts.

 

Just to clarify, are those bills have a purpose? If so, you don't need to delete them in QuickBooks instead you can just change the vendor name. 

 

Also, can you please provide a screenshot for the transaction journal of the bill transactions. This could help us verify if the amount of those bills are positive or negative amounts. Since bills are an expense, it should be recorded as a negative amount.

 

Please keep me posted on how things go with this. I'm here anytime you need further help.

Community Contributor *

Re: fiscal adjustmetns

Thank you for your help!  These are very old items that are coming up in the pay bills section.  When I go to an individual bill, it comes up as a deposit.  I tried to delete one, and it added the money back to a cash account.  (Yikes!)  I have attached a screenshot of the bills to be paid screen.

Community Contributor *

Re: fiscal adjustmetns

Here is a snip of one of the old bills I pulled up.

QuickBooks Team

Re: fiscal adjustmetns

Hi there, @mcclin.

 

Thank you for providing me with screenshots of your bills. Let me guide you on how to delete these bills.

 

Just to make sure we're on the same page, is the bill showing as deposit already paid? If so, you'll need to open the transaction and delete it. Also, when you delete it, it'll reverse the transaction and increase the amount of your cash account.

 

To delete these bills, you may follow these steps:

  1. Click on Vendors from the menu bar.
  2. Choose Vendor Center.
  3. Select the dummy vendor to view the transaction list.
  4. Click on the bill and click on Delete.
  5. Click on OK.

That's it! You've now deleted the bills.

 

Please let me know if you have other concerns. I'll be around to help you.

Community Contributor *

Re: fiscal adjustmetns

I do not want the cash account increased, because these are bills that have been paid.

QuickBooks Team

Re: fiscal adjustmetns

I appreciate your prompt response, @mcclin.

 

Allow me to chime into this conversation and provide you with some clarifications about deleting bills in QuickBooks Desktop.

 

In QuickBooks Desktop, only payments can be linked to an open bill. In your case, you'll need to delete the deposit that is showing on your transaction journal so it won't be recorded as money in the transaction.

 

Once done, you'll need to write a check and use the fix unapplied payments which can help to assign the unapplied payments to the proper bill.

 

To do that:

  1. Click on Accounts at the top menu bar.
  2. Select on Client Data Review.
  3. Choose Fix Unapplied Vendors Payments and Credits.
  4. The account selected should be Accounts Payable.
  5. Select the vendor on the list. The Bills and Charges tab will display any unapplied payments and credits and open the bill for that specific vendor. 
  6. On the Bill and Charges tab, put a check-mark next to the payment or credit on the left pane, and place a check-mark next to the associated open bill on the right pane to apply the payment.
  7. If you would like to apply only part of the credit or payment, enter the partial amount in the Amt to Apply column.
  8. Click the Apply button to assign the payments or credits selected on the left to the selected open bill on the right. The items are then grayed out to indicate that you have already assigned them.
  9. Click Save to begin working on another customer record, or Save & Close to complete the task.

AP.PNG

That should do it!

 

Please let me know how it goes by leaving a reply below. I want to ensure you're taken care of. Have a good one.

Frequent Contributor *

Re: fiscal adjustmetns

I have the desktop version, so I dont think this is a solution for me?  I have tried deleting the transactions, it just increases my payable balance.  These transactions did not exist in SAGE, Quickbooks created these transactions when I imported the data.  they are from 2015.  when i open the transaction, they are credited to an account that quickbooks also created (i did not use nor did it exist in SAGE) called Opening Balance.  SAGE did not use Fiscal Adjustments- Quickbooks also created these journal entries for prior years while transferring the data.

Frequent Contributor *

Re: fiscal adjustmetns

Here are some new screen shots of some of the transactions.  These were never bills that needed to be paid, QB created these when it converted the data from SAGE.  
There was no such thing as a Dummy Vendor, Beginning Balance Equity or Retained Earnings in SAGE.  I dont know what data these entries came from?  SAGE will only let me access current year and 1 previous year of financial information.  I do have access to some archived financials that I found on back up disks.  but again, I wouldnt know what to look for in SAGE to compare to what Quickbooks created

QuickBooks Team

Re: fiscal adjustmetns

Thank you for getting back to us, @clfp.

 

Thank you for the screenshots you've provided. These were very helpful for me to understand your concern further.

 

I'd love to provide some details about your transactions.

 

When importing from Sage, your old transactions were compressed into monthly fiscal adjustments.

 

This said, there's no need to delete the fiscal adjustments. They serve as a compressed record of all your previous transactions to correct your balances in QuickBooks.

 

Accounts such as Opening Balance and Retained Earnings are automatically created. These depends on the account you chose upon signing up.

 

You may also refer to this article for more information: Understand QuickBooks Chart of Accounts.

 

Please fill me in if you have any other concerns. I'll be around to help.

Frequent Contributor *

Re: fiscal adjustmetns

I kind of want to get of them, I am annoyed that they are showing up in my bill payment screen... they are not open invoices that need to be paid.  Why are they considered open invoices? 

QuickBooks Team

Re: fiscal adjustmetns

Thank you for getting back to me, @clfp.

 

Let me provide more information about your fiscal adjustments and help you from there.

 

When you import transactions from other accounting software, your bills are separated from the payments.

 

In the screenshot you've provided above, your fiscal adjustments are associated with your accounts payable. This makes the adjustments show was open bills in QuickBooks.

 

To correct this, you'll need to look for the payments or transactions that match them.

 

Once you've located the transactions, you can then pay the bills, or in your case, adjustments.

 

Feel free to leave a comment below if you have any other concerns.

Frequent Contributor *

Re: fiscal adjustmetns

so how do i do that?  Everything i have tried has messed up my cash on hand or my payables balance

QuickBooks Team

Re: fiscal adjustmetns

Hello there, clfp.

 

I appreciate you taking the time to reach back to us. I want this to be taken care of.

 

As what my colleague mentioned, since you're importing transactions from other software, your bills are separated from the payments. As recommended, you'll need to find those payments, change it to Accounts Payable and match it with the open bill.

 

You may consider going to your register to find those payments.  Let me show you how below:

  1. Go to Banking.
  2. Click Use Register.
  3. Select an Account and click OK.

Once done, you'll want to link those payment to your open bills.

  1. Go to the Vendors menu, then select Pay Bills.
  2. Select the Bill/s corresponding to the Check.
  3. Select Set Credits, then go to the Credits tab.
  4. Put a check on the credit. Change the amount as needed.
  5. Select Done, then choose Pay Selected Bills.

That's it. Don't hesitate to reach out to me if you have any other concerns about fiscal adjustments in QuickBooks Desktop.

Frequent Contributor *

Re: fiscal adjustmetns

I dont have an 'Opening Balance Equity' or 'Retained Earning' account listed in my list of account registers.  Is it the same register if i go into my chart of accounts and open the account?

i am sorry if i am not understanding your instructions.  this is all new to me and i am frustrated about how much extra data and accounts and 'stuff' qb created and added when converting the data.  it took me at least a week to correct payroll accounts and payroll taxes and correcting vendor information.  it was not pretty, i had to continue to use SAGE for almost 2 months while i was correcting employee data and everything else.  i am feeling that it would have been easier and less of a headache to just start over instead of importing/converting historical data.
i have attached some account entries for the 2 accounts i mentioned above

Highlighted
QuickBooks Team

Re: fiscal adjustmetns

Hi there, @clfp.

 

Please allow me to join the thread and help you today so you'll be able to remove/delete the ancient bills created to a dummy vendor.

 

To remove your old/ancient bills, you must delete them one by one manually. On the other hand, if you're using QuickBooks Desktop Enterprise, you have the option to delete/void transactions by batch.

 

To learn more, you may check this article: Delete transactions by batch using Batch Delete/Void Transactions.

 

If the issue persists, I recommend reaching out with our Support Team to check and investigate this further securely. For the support's contact information, you may check it here: Contact the QuickBooks Desktop Customer Support Team.

 

You can always add a post/comment below if you have any other QuickBooks concerns, I'll be right here to help you. Have a good day ahead!