worksheet

# Data for the complete worksheet based on the provided format

# Create an extended data structure to include all columns in the format of the image
columns_data = {
    "Account Titles": df_trial_balance["Account Titles"].tolist() + ["Salaries Payable", "Interest Payable", "Advertising Expense", "Engineering Supplies Expense", "Depreciation Expense", "Interest Expense"],
    "Trial Balance - Debit (₱)": df_trial_balance["Debit (₱)"].tolist() + [""] * 6,
    "Trial Balance - Credit (₱)": df_trial_balance["Credit (₱)"].tolist() + [""] * 6,
    "Adjusting Entries - Debit (₱)": [""] * len(df_trial_balance) + df_adjustments["Debit (₱)"].tolist(),
    "Adjusting Entries - Credit (₱)": [""] * len(df_trial_balance) + df_adjustments["Credit (₱)"].tolist(),
    "Adjusted Trial Balance - Debit (₱)": df_adjusted_trial_balance["Debit (₱)"].tolist() + [""] * (6),
    "Adjusted Trial Balance - Credit (₱)": df_adjusted_trial_balance["Credit (₱)"].tolist() + [""] * (6),
    "Income Statement - Debit (₱)": [""] * len(df_trial_balance) + [""] * 6,  # Placeholder
    "Income Statement - Credit (₱)": [""] * len(df_trial_balance) + [""] * 6,  # Placeholder
    "Balance Sheet - Debit (₱)": [""] * len(df_trial_balance) + [""] * 6,  # Placeholder
    "Balance Sheet - Credit (₱)": [""] * len(df_trial_balance) + [""] * 6   # Placeholder
}

# Create DataFrame for complete worksheet with proper columns
df_complete = pd.DataFrame(columns_data)

# Save the formatted data to an Excel file
file_path_complete_template = "/mnt/data/Complete_Trial_Balance_Template_Ily_Abella_Surveyors.xlsx"
df_complete.to_excel(file_path_complete_template, index=False)

file_path_complete_template