# EKM to QuickBooks Zap - how to reduce task usage

• 5 replies
• 27 views

Userlevel 1
• Beginner
• 2 replies

I have a Zap that links EKM Sales to QuickBooks to create a Sales Receipt. To make the zap work I have 5 steps that

• convert the VAT rate to a code (the receipts tend to be split rated) for each line item  (number.spreadsheet.formula)
• work out the price before VAT for each line item (spreadsheet formula),
• work out the delivery before VAT (number.spreadsheet.formula) and
• each line’s subtotal (Utilities)
• Work out the code for the bank the sale has been sent to (paypal or current through Stripe)  (spreadsheet formula)

This means each zap is 6 tasks and eats it’s way through my allowance quickly

Is there any way for me to combine these tasks?

icon

Best answer by GetUWired 25 May 2021, 15:30

You can multiple with the ‘*’ operator https://www.pythoncentral.io/multiplying-dividing-numbers-python/

You can loop through pushing to the new list using the below code

``lineVAT = input_data['ItemVAT']lineVAT_list = lineVAT.split(",")List_Line_VAT = []for i in range(len(lineVAT_list)):    if lineVAT_list[i] == '0' :        List_Line_VAT.append('11')    else :        List_Line_VAT.append('3')``

View original

### 5 replies

Userlevel 7
+9

Hi @AngelsLedgers

The only way to consolidate many formatting steps into one would be by utilizing a code block

Userlevel 1

Thank you for this I have managed to combine the Delivery and Bank into one task

WIth the other one they are lists with a value for each line item. I am struggling to figure out how to change the values in the array/list to data QuickBooks can use for example

From EKM
ItemVAT = 0, 0

Me trying to convert 0 to value of 11 otherwise value of 3

This is what I have so far but I think my if statement is incorrect as I don’t understand how to the value in the new list

lineVAT = input_data['ItemVAT']
lineVAT_list = lineVAT.split(",")
List_Line_VAT = []

for i in range(0,len(lineVAT_list)):
if lineVAT_list[i] == '0' :
List_Line_VAT.append('11')
else :
List_Line_VAT.append('3')

Also how do I do a multply in python?

Thanks

Userlevel 7
+9

You can multiple with the ‘*’ operator https://www.pythoncentral.io/multiplying-dividing-numbers-python/

You can loop through pushing to the new list using the below code

``lineVAT = input_data['ItemVAT']lineVAT_list = lineVAT.split(",")List_Line_VAT = []for i in range(len(lineVAT_list)):    if lineVAT_list[i] == '0' :        List_Line_VAT.append('11')    else :        List_Line_VAT.append('3')``

Userlevel 1

Thank you so much for your help @GetUWired I have managed to get all the tasks coded in Python meaning I have gone from 6 tasks to 2. I am so pleased, particularly as it meant I could use my old coding skills from 15 years ago

Userlevel 7
+9

@AngelsLedgers

That is great news!