Skip to main content
H
HMAT
January 21, 2025
Question

Sales provision

  • January 21, 2025
  • 1 reply
  • 0 views

Hello Everyone!

I'm trying to figure out how to upload a CVS for the sales provision.

I need to record this within the "Sales Provision" account in my Chart of Accounts.

Should I use the "Sales receipt" import function?; or do you have another suggestion? 

 

Thanks in advance!

1 reply

R
RhoiceW
January 21, 2025

When importing transactions directly for Sales Provision, there's no direct option or form to enter it, HMAT. Let me provide the steps on how you can import your Sales Provisions into your QBO account.

 

First, I'd like to inform you that Sales Receipts and Provisions differ. A Sales Receipt is mainly used for goods/services rendered at purchase or if your customers give you immediate payment.

 

On the other hand, a Sales Provision is a liability as it represents an estimated obligation that the company expects to incur. For now, you can enter them using a Journal Entry in QBO.

 

Here's how:

 

  1. Click on + New.
  2. Choose Journal Entry.
  3. In the first line, select an account from the Account drop-down menu. Enter the amount in either the debit or credit column, depending on your requirement.
  4. On the next line, select the corresponding account you're transferring money to or from. Ensure to enter the same amount in the opposite column (debit or credit), depending on the previous entry.
  5. Verify the amounts – the credit column on one line should match the debit column on the other line, ensuring the accounts are balanced.
  6. Add a memo to provide context for the journal entry.
  7. Click on Save and new or Save and close.

 

Before proceeding, I'd suggest reaching out to your accountant for guidance on assigning them.

 

Also, you can refer to this article to learn how to import your Journal Entries in QBO: Create journal entries in QBO.
 

Additionally, if you want to delete your created Journal Entries, you can do so by visiting our article in QBO.

 

Furthermore, you may enhance your financial trajectory by working with our QuickBooks Live Expert Assisted team. These financial maestros streamline your processes and provide bespoke advice to meet your business's unique needs. Click now to embark on a new era of financial clarity and success.

Thanks for choosing QuickBooks Online! We’re here to make managing your finances as smooth as possible. If you ever need a hand, I'm just a message away.

H
HMATAuthor
January 21, 2025

Thank you! I was exploring the "Sales Receipt" option suggested by Google Labs, but I've since learned that using Journal Entries (JEs) is the correct approach for recording sales provisions in QuickBooks Online (QBO). I'll be trying the sync option with the template for the next month's close.

Currently, I'm manually entering these provisions, but with approximately 1,400 monthly entries, this is unsustainable. I'm looking for a way to automate this process, and I believe the sync option will achieve this.

To confirm, there's no direct way to upload sales provisions from Excel into QBO. While I can use JEs, these entries will be identifiable as "Sales Provision" entries because of the accounts chosen in the JE. Is that correct?

C
ChristineJoieR
January 21, 2025

Yes, HMAT. QuickBooks will recognize this transaction within the Journal Entry if you have established accounts specifically for the Sales Provision.

 

When setting up an account, it is essential to enter Sales Provision in the Memo field. This will make it easier to locate these accounts while tracking these transactions in QuickBooks Online.

 

Follow the steps below:

 

  1. Choose the Chart of Account for the Transaction Menu.
  2. Press the New button.
  3. Enter New Account name, Account Type, Detail Type.
  4. Next, add Sales Provision under the Description field.
  5. Save once done.

 

Moreover, you can upload journal entries via CSV file or Excel as a workaround, since downloading them automatically isn't supported in QBO.

 

  1. Go to Settings , then select Import Data.
  2. Choose Journal Entries.
  3. Select Browse on the Download page.
  4. Note: If you need help formatting your journal entries, select Download a sample file.
  5. Locate your CSV file. Select Open, then Next.
  6. Map your information. Your Field represents the headers on your spreadsheet. From each small arrow ▼ icon, select the one that matches a field in QuickBooks Online.
  7. Pick Next and click the Start import.
  8. Choose Done.

 

To ensure a smooth mapping process and prevent import issues, I recommend downloading a sample file and following the specified format. For more details, please refer to this page: Import journal entries in QuickBooks Online.

 

However, if you're using other platform and need to sync them in QBO, consider using a third-party application. Visit this page to find an integrated platform that will help transmit your Sales Provision transaction to QBO: QuickBooks Online App Center.

 

Additionally, if you need assistance to reverse or delete your journal entries, check out this page that guides you through the process: Reverse or delete a journal entry in QuickBooks Online.

 

Aside from that, I recommend exploring our QuickBooks Live Expert Assisted service to improve your QuickBooks Online (QBO) experience. Our expert team is available to provide immediate support tailored to your business's specific needs. They will help you navigate the features of your plan, as well as manage your accounts, customers, and vendors effectively.

 

If you need more guidance about managing your journal entries or sales provisions, let me know in the Comment section. I'll do my best to help you achieve your goals within QuickBooks Online.

Terms & ConditionsAccessibility statement