Export to IIF payout and charges

import os
import stripe
import json
import time
#https://stripe.com/docs/connect/express-dashboard
#https://stripe.com/docs/recipes/seller-dashboard#building-a-seller-dashboard
# This is using a modified version of https://github.com/ddehghan/python-QuickBooks

stripe.api_key = "sk_test_Change_ME"

def date_converter(date_string):#converts YYYY-MM-DD to Epoch time
    target_timestamp = time.strptime(date_string, '%Y-%m-%d')
    return round(time.mktime(target_timestamp))

date_start=(date_converter('2019-05-01')) #Start export range
date_end=(date_converter('2019-06-20')) #End export range

export_file="ExportToQB" #name for IIF file
connected_id="sk_test_Change_me_to_connected_account"
is_connected=False # True (for connected account put connected_id) or False (for standalone does not read the connected_id)
head = "!ACCNT	NAME	ACCNTTYPE	SCD\r\n"\
           + "ACCNT	Stripe Account	BANK\r\n"\
           + "ACCNT	Stripe Payment Processing Fees	EXP\r\n"\
           + "ACCNT	Stripe Returns	INC\r\n"\
           + "ACCNT	Stripe Sales	INC\r\n"\
           + "ACCNT	Stripe Checking Account	BANK\r\n"\
           + "ACCNT	Stripe Third-party Account	EXP	561\r\n"\
           + "ACCNT	Stripe Other Fees	EXP\r\n"\
           + "ACCNT	Stripe Processing Fees Adj	EXP\r\n"\
           + "ACCNT	Stripe Other Income	INC\r\n"\
           + "!VEND	NAME	1099\r\n"\
           + "!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	AMOUNT	MEMO	NAME\r\n"\
           + "!SPL	SPLID	TRNSTYPE	DATE	ACCNT	AMOUNT	MEMO	NAME\r\n"\
    + "!ENDTRNS\r\n"
template = "TRNS		DEPOSIT	%s	Stripe Checking Account	%s	Transfer ID: %s | STRIPE PAYOUT\r\n"\
               + "SPL		DEPOSIT	%s	Stripe Account	-%s	Transfer ID: %s | STRIPE PAYOUT\r\n"\
    + "ENDTRNS\r\n"
template2 = "TRNS	GENERAL JOURNAL	%s	Stripe Sales	-%s	Charge ID: %s | %s | %s %s\r\n"
template3 = "SPL		GENERAL JOURNAL	%s	Stripe Payment Processing Fees	%s	Fees for charge ID: %s \r\n"
template4 = "SPL		GENERAL JOURNAL	%s	Stripe Account	%s	Net for charge ID: %s	\r\n"\
    + "ENDTRNS\r\n"

PROJECT_ROOT = os.path.dirname(os.path.realpath(__file__))
def main(input_file_name,is_connected):
    output_file = open(os.path.join(PROJECT_ROOT, input_file_name + '.iif'), 'w')
    if is_connected is True:
      data=stripe.Payout.list(arrival_date={'gte': date_start,'lte': date_end},status="paid", stripe_account=connected_id);
    else:
      data=stripe.Payout.list(arrival_date={'gte': date_start,'lte': date_end},status="paid");

    json.dumps(data);
    x=len(data["data"])

    output_file.write(head)

    payoutlist=[]
    for trans in range(x):
          date=(data["data"][trans]["arrival_date"])
          date=time.strftime('%m/%d/%Y', time.localtime(date))
          amount=(float(data["data"][trans]["amount"])/ 100)
          payoutid=(data["data"][trans]["id"])
          json.dumps(payoutlist)
          payoutlist.append((str(trans),payoutid))
          output_file.write(template % (date,amount,payoutid,date,amount, payoutid))
          if trans==x:
            continue

    z=(json.dumps(payoutlist));
    qq=json.loads(z)

    for wi in range(len(qq)):
      if is_connected is True:
        balance=stripe.BalanceTransaction.list(payout = qq[wi][1], type="charge", stripe_account=connected_id);
      else:
        balance=stripe.BalanceTransaction.list(payout = qq[wi][1], type="charge");
      json.dumps(balance)
      try:
        ch_date=balance["data"][wi]["available_on"]
        ch_date=time.strftime('%m/%d/%Y', time.localtime(ch_date))
        ch_amount=float((balance["data"][wi]["amount"])/ 100)
        ch_net=float((balance["data"][wi]["net"])/ 100)
        ch_id=balance["data"][wi]["source"]
      except:
        continue
      for foo in range(len(balance["data"])):
        if is_connected is True:
          balance=stripe.BalanceTransaction.list(payout = qq[wi][1], type="charge", stripe_account=connected_id);
        else:
          balance=stripe.BalanceTransaction.list(payout = qq[wi][1], type="charge");
        json.dumps(balance)
        ch_desc=balance["data"][foo]["description"]
        ch_id=balance["data"][foo]["source"]
        stripefee=float((balance["data"][foo]["fee"])/ 100)
        #getting charge information from payoutCharge
        if is_connected is True:
          ch_data=stripe.Charge.retrieve(ch_id, stripe_account=connected_id);
        else:
          ch_data=stripe.Charge.retrieve(ch_id);
        json.dumps(ch_data)
        if is_connected is True:
          in_data=stripe.Invoice.retrieve(ch_data["invoice"], stripe_account=connected_id);
        else:
          in_data=stripe.Invoice.retrieve(ch_data["invoice"]);
        json.dumps(in_data)
        in_email=(in_data["customer_email"])
        in_plan=(in_data["lines"]["data"])
        json.dumps(in_plan)
        ch_data_date=time.strftime('%m/%d/%Y', time.localtime(ch_data["created"]))
        try:
          in_planname=in_plan[0]["plan"]["nickname"]
          output_file.write(template2 % (ch_data_date,ch_amount,ch_id,ch_desc + "| Plan ID: " + in_planname,           ch_desc,in_email))
        except:
            continue
            output_file.write(template2 % (ch_data_date,ch_amount,ch_id,ch_desc,           ch_desc,in_email))

        output_file.write(template3 % (ch_data_date,stripefee,ch_id))
        output_file.write(template4 % (ch_data_date,ch_net,ch_id))
        continue
    print("The file named " + PROJECT_ROOT + "/" + input_file_name + ".iif has been updated for your review")

main(export_file,is_connected)