cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Estherallpipe
Level 1

importing bills error

When importing bills using a .csv file there is a bug. I import the bills fine for CIS subcontractors,  i select zero VAT or Exclusive of VAT (i've tried both) on the CIS lines.  The CIS is not deducted on the imported bill unless you click into the bill and make any edit.  It's only on performing an action on an imported bill that the CIS is deducted.  It's really annoying, it means you have to click into every imported bill.

Solved
Best answer November 30, 2021

Accepted Solutions
GeorgiaC
QuickBooks Team

importing bills error

Hi AB74, thanks for joining this thread - CIS is not supported with the import bills feature, and we do not currently have a timescale for implementation. We'd be grateful if you could leave feedback for this by selecting the Cog > Feedback within your account, as this will be submitted directly to our developers who implement changes based on customer demand amongst other variables. :folded_hands:

View solution in original post

8 REPLIES 8
Catherine_B
QuickBooks Team

importing bills error

Hello there, Estherallpipe.

 

VAT codes are mapped so there is no need to change your VAT codes to QuickBooks VAT code formats before importing. You can map your VAT codes and ensure that the codes in your CSV files are in sync with the ones in QuickBooks. To guide you through the mapping of your importing your bills, you can use this link: Import your bills to QuickBooks.

 

Keep me posted if you need anything else. Take care!

 

 

Estherallpipe
Level 1

importing bills error

yes I understand this and have imported the bill correctly.  The difficulty is that on nice a bill is imported if you look at the bill list against the supplier the cis is not deducted.  If you open the bill and click in any field make a change and change it back to the original imported value only then is the CIS deducted.  I believe it to be a bug with the system. 

EmmaM
QuickBooks Team

importing bills error

Hello Estherallpipe, The bills import feature does not include cis deductions so you would need to import the bill and then  add the CIS on those bills which need the cis deductions.

Estherallpipe
Level 1

importing bills error

that doesnt really make sense as you can choose cis as the category for the line amount - is it something you will add?  How do customers view your roadmap?

Ashleigh1
QuickBooks Team

importing bills error

Hello Esterallpipe, we are not sure if or when it will be implemented into Quickbooks. We would advise you leave feedback in the product this gets sent straight to our developers team. 

kev12
Level 1

importing bills error

I need this feature, It is pointless importing bills if I have to manually adjust them all

AB74
Level 3

importing bills error

Approx 9 months later and still no ability to map the CIS on a imported invoice. Amending every import is not a worthwhile option.

Any plans to include this function yet?

GeorgiaC
QuickBooks Team

importing bills error

Hi AB74, thanks for joining this thread - CIS is not supported with the import bills feature, and we do not currently have a timescale for implementation. We'd be grateful if you could leave feedback for this by selecting the Cog > Feedback within your account, as this will be submitted directly to our developers who implement changes based on customer demand amongst other variables. :folded_hands:

Need to get in touch?

Contact us