Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Feb 21, 2021 9:54 PM UTC
Solved

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.

GeorgiaCAnswer
Level 13
Nov 30, 2021 12:48 PM UTC

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?


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. 🙏

8 replies

Level 9
Feb 22, 2021 2:45 AM UTC

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!

 

 

Feb 22, 2021 8:30 AM UTC

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. 

Level 10
Feb 22, 2021 10:08 AM UTC

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.