{"id":12847,"date":"2024-05-30T16:02:49","date_gmt":"2024-05-30T07:02:49","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=12847"},"modified":"2024-05-31T10:46:25","modified_gmt":"2024-05-31T01:46:25","slug":"handling-hierarchical-tidy-data-in-financial-reporting","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=12847&lang=en","title":{"rendered":"Handling Hierarchical Tidy Data in Financial Reporting"},"content":{"rendered":"

Views: 13<\/p>

\n

Handling Hierarchical Tidy Data in Financial Reporting<\/h1>\n
\nNobuyuki SAMBUICHI<\/span>\n<\/div>\n<\/div>\n
\n
\n
\n
\n

\nIn this blog post, we will explore how to handle hierarchical tidy data in financial reporting. We will discuss how to merge necessary data into target rows to summarize amounts based on debit\/credit codes, account numbers, and months, ensuring efficient data management and avoiding redundancy.\n<\/p><\/blockquote>\n<\/div>\n<\/div>\n<\/div>\n

\n

1. Characteristics of a hierarchical tidy data<\/h2>\n
\n
\n

Hierarchical tidy data reports different levels of observation in different rows, resulting in no redundant report files. However, we need to merge necessary data into a target row to summarize amounts based on debit\/credit codes, account numbers, and months.<\/p>\n<\/div>\n

\n

The entered date is reported in a header entry-level row, and data for debit\/credit code, journal account number, and amount is reported in entry line-level rows. We need to merge the date into entry line-level data, which will be explained in the later sections.<\/p>\n<\/div>\n

\n

The final results, showing the sum of CC05hW_01_target<\/code> for each combination of JP04a_GL02_03_month<\/code>, JP05a_GL03_04<\/code>, JP13a_BS16_01<\/code>, and JP13a_BS16_02<\/code>.<\/p>\n<\/div>\n

\n
\n
7. Final Results DataFrame with Sum by Combination:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01        JP13a_BS16_02  CC05hW_01_target\r\n0             2021-04             D            150      Receivable Note          20392404\r\n1             2021-04             C            152  Accounts Receivable          29217041\r\n2             2021-04             D            131      Regular Deposit           8823062\r\n3             2021-04             D            741         Payment Fees              1575\r\n4             2021-05             D            152  Accounts Receivable           6682852\r\n5             2021-05             C            511                Sales           6540100\r\n6             2021-05             C            521        Sales Returns            142752<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
2. Source Code and Explanation<\/h2>\n
\n
\n
\n
import pandas as pd\r\n\r\n# Load the CSV file\r\nfile_path = '2405\/240530\/tidyGL05-31_translated.csv'\r\n\r\n# Read the CSV file into a DataFrame\r\ndf = pd.read_csv(file_path, encoding='utf-8-sig')\r\n\r\n# Strip any leading\/trailing spaces from column names\r\ndf.columns = df.columns.str.strip()\r\n\r\n# Convert relevant columns to appropriate data types\r\ndf['JP05a'] = pd.to_numeric(df['JP05a'], errors='coerce').astype('Int64')\r\ndf['JP12a'] = pd.to_numeric(df['JP12a'], errors='coerce').astype('Int64')\r\ndf['BS04cc'] = pd.to_numeric(df['BS04cc'], errors='coerce').astype('Int64')\r\ndf['CC05hW_01'] = pd.to_numeric(df['CC05hW_01'], errors='coerce').astype('Int64')\r\ndf['JP13a_BS16_01'] = pd.to_numeric(df['JP13a_BS16_01'], errors='coerce').astype('Int64')\r\n\r\n# Ensure JP05a_GL03_04 is correctly formatted as a string for comparison\r\ndf['JP05a_GL03_04'] = df['JP05a_GL03_04'].astype(str)\r\n\r\n# Convert JP04a_GL02_03 to datetime, handle non-standard date formats\r\ndf['JP04a_GL02_03'] = pd.to_datetime(df['JP04a_GL02_03'], errors='coerce')\r\n\r\n# Extract month from JP04a_GL02_03 and create a new column for it\r\ndf['JP04a_GL02_03_month'] = df['JP04a_GL02_03'].dt.to_period('M').astype(str)\r\n\r\n# Print initial DataFrame\r\nprint(\"1. Initial DataFrame:\")\r\nprint(df.head())\r\n\r\n# Extract rows where JP12a=0 and BS04cc=0 to collect the target CC05hW_01 values\r\ntarget_rows = df[(df['JP12a'] == 0) & (df['BS04cc'] == 0) & (df['JP05a'] != 0)][['JP04a', 'JP05a', 'CC05hW_01']]\r\nprint(\"\\n2. Target Rows:\")\r\nprint(target_rows.head())\r\n\r\n# Rename the target column for clarity before merging\r\ntarget_rows = target_rows.rename(columns={'CC05hW_01': 'CC05hW_01_target'})\r\n\r\n# Extract rows where only JP04a has value and JP05a, JP12a, BS04cc are all zero\r\njp04a_rows = df[(df['JP12a'] == 0) & (df['BS04cc'] == 0) & (df['JP05a'] == 0)][['JP04a', 'JP04a_GL02_03', 'JP04a_GL02_03_month']]\r\n\r\n# Rename the columns for clarity before merging\r\njp04a_rows = jp04a_rows.rename(columns={'JP04a_GL02_03': 'JP04a_GL02_03_value', 'JP04a_GL02_03_month': 'JP04a_GL02_03_month_value'})\r\n\r\n# Merge the target CC05hW_01 values back into the main DataFrame\r\ndf = pd.merge(df, target_rows, on=['JP04a', 'JP05a'], how='left')\r\n\r\n# Merge the JP04a_GL02_03 and JP04a_GL02_03_month values back into the main DataFrame\r\ndf = pd.merge(df, jp04a_rows, on='JP04a', how='left')\r\n\r\n# Update the main DataFrame with the correct JP04a_GL02_03 and JP04a_GL02_03_month values\r\ndf['JP04a_GL02_03'] = df['JP04a_GL02_03_value'].combine_first(df['JP04a_GL02_03'])\r\ndf['JP04a_GL02_03_month'] = df['JP04a_GL02_03_month_value'].combine_first(df['JP04a_GL02_03_month'])\r\n\r\n# Drop the temporary columns used for merging\r\ndf.drop(columns=['JP04a_GL02_03_value', 'JP04a_GL02_03_month_value'], inplace=True)\r\n\r\n# Print DataFrame after merging and updating\r\nprint(\"\\n3. DataFrame after merging and updating:\")\r\nprint(df.head())\r\n\r\n# Collect all unique combinations of JP05a_GL03_04, JP13a_BS16_01, and JP13a_BS16_02\r\nunique_combinations = df[['JP05a_GL03_04', 'JP13a_BS16_01', 'JP13a_BS16_02']].drop_duplicates()\r\nprint(\"\\n4. Unique Combinations:\")\r\nprint(unique_combinations)\r\n\r\n# Initialize an empty DataFrame to store the results\r\nresults = pd.DataFrame()\r\n\r\n# Iterate over each unique combination to filter and aggregate data\r\nfor _, row in unique_combinations.iterrows():\r\n    jp05a_gl03_04 = row['JP05a_GL03_04']\r\n    jp13a_bs16_01 = row['JP13a_BS16_01']\r\n    jp13a_bs16_02 = row['JP13a_BS16_02']\r\n    \r\n    # Filter the DataFrame based on the current combination\r\n    filtered_df = df[(df['JP05a_GL03_04'] == jp05a_gl03_04) & \r\n                     (df['JP13a_BS16_01'] == jp13a_bs16_01) & \r\n                     (df['JP13a_BS16_02'] == jp13a_bs16_02) & \r\n                     df['CC05hW_01_target'].notna()]\r\n\r\n    print(f\"\\n5. Filtered DataFrame for combination ({jp05a_gl03_04}, {jp13a_bs16_01}, {jp13a_bs16_02}):\")\r\n    print(filtered_df)\r\n\r\n    if not filtered_df.empty:\r\n        # Print the results without dropping NaN values\r\n        for _, filtered_row in filtered_df.iterrows():\r\n            date = filtered_row['JP04a_GL02_03'] if pd.notna(filtered_row['JP04a_GL02_03']) else 'N\/A'\r\n            debit_credit_code = filtered_row['JP05a_GL03_04'] if pd.notna(filtered_row['JP05a_GL03_04']) else 'N\/A'\r\n            ledger_account_number = filtered_row['JP13a_BS16_01'] if pd.notna(filtered_row['JP13a_BS16_01']) else 'N\/A'\r\n            ledger_account_name = filtered_row['JP13a_BS16_02'] if pd.notna(filtered_row['JP13a_BS16_02']) else 'N\/A'\r\n            amount = filtered_row['CC05hW_01_target'] if pd.notna(filtered_row['CC05hW_01_target']) else 'N\/A'\r\n\r\n            print(f\"Date: {date}, \"\r\n                  f\"Debit\/Credit Code: {debit_credit_code}, \"\r\n                  f\"Ledger Account Number: {ledger_account_number}, \"\r\n                  f\"Ledger Account Name: {ledger_account_name}, \"\r\n                  f\"Amount: {amount}\")\r\n\r\n        # Ensure columns used for grouping are not null\r\n        filtered_df = filtered_df.fillna('N\/A')\r\n\r\n        # Group by the required columns and aggregate the sum of 'CC05hW_01_target'\r\n        result = filtered_df.groupby(\r\n            ['JP04a_GL02_03_month', 'JP05a_GL03_04', 'JP13a_BS16_01', 'JP13a_BS16_02']\r\n        )['CC05hW_01_target'].sum().reset_index()\r\n\r\n        print(\"\\n6. Intermediate Result:\")\r\n        print(result)\r\n\r\n        # Append the result to the results DataFrame\r\n        results = pd.concat([results, result], ignore_index=True)\r\n\r\n# Display the final results\r\nprint(\"\\n7. Final Results DataFrame with Sum by Combination:\")\r\nprint(results)\r\n\r\n# If you need to save the result to a new CSV file, uncomment the following line:\r\n# results.to_csv('data\/_PCA\/try\/sum_by_combination.csv', index=False, encoding='utf-8-sig')<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
3. Explanation of Each Step<\/h2>\n
\n
\n
3.1. Load and Read the CSV File:<\/h3>\n
\n
First, let’s start with our initial data and the setup required to handle it. The source CSV file contains the hierarchical tidy data.<\/p>\n<\/div>\n
\n
The following Python script reads the CSV file, processes the data, and merges necessary information into the target rows.<\/p>\n<\/div>\n
\n
\n
file_path = 'tidyGL05-31_translated.csv'\r\ndf = pd.read_csv(file_path, encoding='utf-8-sig')<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
\n
3.2. Strip Leading\/Trailing Spaces from Column Names:<\/h3>\n
\n
\n
df.columns = df.columns.str.strip()<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This ensures that any extra spaces in the column names are removed, which helps in avoiding errors during data manipulation.<\/p>\n<\/div>\n<\/div>\n
\n
3.3. Convert Relevant Columns to Appropriate Data Types:<\/h3>\n
\n
\n
df['JP05a'] = pd.to_numeric(df['JP05a'], errors='coerce').astype('Int64')\r\ndf['JP12a'] = pd.to_numeric(df['JP12a'], errors='coerce').astype('Int64')\r\ndf['BS04cc'] = pd.to_numeric(df['BS04cc'], errors='coerce').astype('Int64')\r\ndf['CC05hW_01'] = pd.to_numeric(df['CC05hW_01'], errors='coerce').astype('Int64')\r\ndf['JP13a_BS16_01'] = pd.to_numeric(df['JP13a_BS16_01'], errors='coerce').astype('Int64')<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
Columns ‘JP05a’, ‘JP12a’, ‘BS04cc’ are dimension sequence number.
\nColumn ‘CC05hW_01’ is monetary amount in JPY which has no minor unit.
\nColumn ‘JP13a_BS16_01’ is a chart of accounts number.
\nThese lines convert specific columns to numeric data types, handling any errors by coercing them to NaN and then converting them to the nullable integer type (Int64<\/code>).<\/p>\n<\/div>\n<\/div>\n
\n
3.4. Ensure JP05a_GL03_04 is Correctly Formatted as a String:<\/h3>\n
\n
\n
df['JP05a_GL03_04'] = df['JP05a_GL03_04'].astype(str)<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This ensures that JP05a_GL03_04<\/code> is a debit\/credit code and treated as a string for consistent comparison during filtering and merging operations.<\/p>\n<\/div>\n<\/div>\n
\n
3.5. Convert JP04a_GL02_03 to Datetime:<\/h3>\n
\n
\n
df['JP04a_GL02_03'] = pd.to_datetime(df['JP04a_GL02_03'], errors='coerce')<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This line converts the JP04a_GL02_03<\/code> column to datetime format, handling non-standard date formats by coercing errors to NaT.<\/p>\n<\/div>\n<\/div>\n
\n
3.6. Extract Month from JP04a_GL02_03:<\/h3>\n
\n
\n
df['JP04a_GL02_03_month'] = df['JP04a_GL02_03'].dt.to_period('M').astype(str)<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This extracts the month from the JP04a_GL02_03<\/code> datetime column and creates a new column JP04a_GL02_03_month<\/code>.<\/p>\n<\/div>\n<\/div>\n
\n
3.7. Print Initial DataFrame:<\/h3>\n
\n
\n
print(\"1. Initial DataFrame:\")\r\nprint(df.head())<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
Printing the initial DataFrame allows us to verify the initial data and ensure that the data types and values are correctly formatted.<\/p>\n<\/div>\n
\n
\n
1. Initial DataFrame:\r\n   JP04a  JP05a  JP12a  BS04cc            CC03dh_01  JP04a_GL02_01  ... JP01c_BS28_01   JP01c_BS28_02  BS04cc_01          BS04cc_02   BS04cc_03  JP04a_GL02_03_month\r\n0      1      0      0       0  2021-02-01T13:55:00          273.0  ...           NaN             NaN        NaN                NaN         NaN              2021-04\r\n1      1      2      0       0                  NaN            NaN  ...            00  Not Applicable        NaN                NaN         NaN                  NaT\r\n2      1      2      0       1                  NaN            NaN  ...           NaN             NaN        0.0  Common Department  Department                  NaT\r\n3      1      3      0       0                  NaN            NaN  ...            00  Not Applicable        NaN                NaN         NaN                  NaT\r\n4      1      3      1       0                  NaN            NaN  ...           NaN             NaN        NaN                NaN         NaN                  NaT\r\n\r\n[5 rows x 24 columns]<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
\n
3.8. Extract Target Rows:<\/h3>\n
\n
\n
target_rows = df[(df['JP12a'] == 0) & (df['BS04cc'] == 0) & (df['JP05a'] != 0)][['JP04a', 'JP05a', 'CC05hW_01']]\r\nprint(\"\\n2. Target Rows:\")\r\nprint(target_rows.head())<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This extracts rows where JP12a<\/code> and BS04cc<\/code> are zero, but JP05a<\/code> is not zero, to collect the CC05hW_01<\/code> values.<\/p>\n<\/div>\n
\n
\n
2. Target Rows:\r\n    JP04a  JP05a  CC05hW_01\r\n1       1      2   20392404\r\n3       1      3   20392404\r\n7       2      2    2186153\r\n10      2      3    2186153\r\n13      2      5        735<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
\n
3.9. Rename Target Column for Clarity:<\/h3>\n
\n
\n
target_rows = target_rows.rename(columns={'CC05hW_01': 'CC05hW_01_target'})<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
Renaming the target column helps in distinguishing it during the merging process.<\/p>\n<\/div>\n<\/div>\n
\n
3.10. Extract Rows with Only JP04a Value:<\/h3>\n
\n
\n
jp04a_rows = df[(df['JP12a'] == 0) & (df['BS04cc'] == 0) & (df['JP05a'] == 0)][['JP04a', 'JP04a_GL02_03', 'JP04a_GL02_03_month']]\r\njp04a_rows = jp04a_rows.rename(columns={'JP04a_GL02_03': 'JP04a_GL02_03_value', 'JP04a_GL02_03_month': 'JP04a_GL02_03_month_value'})<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This extracts rows where JP04a<\/code> has a value and other specified columns are zero. The relevant columns are renamed for clarity during merging.<\/p>\n<\/div>\n<\/div>\n
\n
3.11. Merge Target Rows Back into Main DataFrame:<\/h3>\n
\n
\n
df = pd.merge(df, target_rows, on=['JP04a', 'JP05a'], how='left')<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This merges the target CC05hW_01<\/code> values back into the main DataFrame based on JP04a<\/code> and JP05a<\/code>.<\/p>\n<\/div>\n<\/div>\n
\n
3.12. Merge JP04a Values into Main DataFrame:<\/h3>\n
\n
\n
df = pd.merge(df, jp04a_rows, on='JP04a', how='left')<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This merges the JP04a_GL02_03<\/code> and JP04a_GL02_03_month<\/code> values back into the main DataFrame based on JP04a<\/code>.<\/p>\n<\/div>\n<\/div>\n
\n
3.13. Update Main DataFrame with Correct Values:<\/h3>\n
\n
\n
df['JP04a_GL02_03'] = df['JP04a_GL02_03_value'].combine_first(df['JP04a_GL02_03'])\r\ndf['JP04a_GL02_03_month'] = df['JP04a_GL02_03_month_value'].combine_first(df['JP04a_GL02_03_month'])\r\ndf.drop(columns=['JP04a_GL02_03_value', 'JP04a_GL02_03_month_value'], inplace=True)<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This updates the main DataFrame with the correct JP04a_GL02_03<\/code> and JP04a_GL02_03_month<\/code> values using the combine_first<\/code> method, which prioritizes non-null values from the first Series. The temporary columns used for merging are then dropped.<\/p>\n<\/div>\n<\/div>\n
\n
3.14. Print DataFrame After Merging and Updating:<\/h3>\n
\n
\n
print(\"\\n3. DataFrame after merging and updating:\")\r\nprint(df.head())<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
Printing the DataFrame after merging and updating allows us to verify that the data has been correctly merged and updated.<\/p>\n<\/div>\n
\n
\n
3. DataFrame after merging and updating:\r\n   JP04a  JP05a  JP12a  BS04cc            CC03dh_01  JP04a_GL02_01  ...   JP01c_BS28_02 BS04cc_01          BS04cc_02   BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n0      1      0      0       0  2021-02-01T13:55:00          273.0  ...             NaN       NaN                NaN         NaN             2021-04              <NA>\r\n1      1      2      0       0                  NaN            NaN  ...  Not Applicable       NaN                NaN         NaN             2021-04          20392404\r\n2      1      2      0       1                  NaN            NaN  ...             NaN       0.0  Common Department  Department             2021-04          20392404\r\n3      1      3      0       0                  NaN            NaN  ...  Not Applicable       NaN                NaN         NaN             2021-04          20392404\r\n4      1      3      1       0                  NaN            NaN  ...             NaN       NaN                NaN         NaN             2021-04          20392404\r\n\r\n[5 rows x 25 columns]<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
\n
3.15. Collect Unique Combinations:<\/h3>\n
\n
\n
unique_combinations = df[['JP05a_GL03_04', 'JP13a_BS16_01', 'JP13a_BS16_02']].drop_duplicates()\r\nprint(\"\\n4. Unique Combinations:\")\r\nprint(unique_combinations)<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This collects all unique combinations of JP05a_GL03_04<\/code>, JP13a_BS16_01<\/code>, and JP13a_BS16_02<\/code> to facilitate filtering and aggregating data.<\/p>\n<\/div>\n
\n
\n
4. Unique Combinations:\r\n   JP05a_GL03_04  JP13a_BS16_01        JP13a_BS16_02\r\n0            nan           <NA>                  NaN\r\n1              D            150      Receivable Note\r\n3              C            152  Accounts Receivable\r\n7              D            131      Regular Deposit\r\n13             D            741         Payment Fees\r\n31             D            152  Accounts Receivable\r\n34             C            511                Sales\r\n49             C            521        Sales Returns<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
\n
3.16. Initialize Results DataFrame:<\/h3>\n
\n
\n
results = pd.DataFrame()<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
An empty DataFrame is initialized to store the results of the aggregation.<\/p>\n<\/div>\n<\/div>\n
\n
3.17. Iterate Over Each Unique Combination to Filter and Aggregate Data:<\/h3>\n
\n
\n
for _, row in unique_combinations.iterrows():\r\n    jp05a_gl03_04 = row['JP05a_GL03_04']\r\n    jp13a_bs16_01 = row['JP13a_BS16_01']\r\n    jp13a_bs16_02 = row['JP13a_BS16_02']\r\n\r\n    filtered_df = df[(df['JP05a_GL03_04'] == jp05a_gl03_04) &\r\n                     (df['JP13a_BS16_01'] == jp13a_bs16_01) &\r\n                     (df['JP13a_BS16_02'] == jp13a_bs16_02) &\r\n                     df['CC05hW_01_target'].notna()]\r\n\r\n    print(f\"\\n5. Filtered DataFrame for combination ({jp05a_gl03_04}, {jp13a_bs16_01}, {jp13a_bs16_02}):\")\r\n    print(filtered_df)\r\n\r\n    if not filtered_df.empty:\r\n        for _, filtered_row in filtered_df.iterrows():\r\n            date = filtered_row['JP04a_GL02_03'] if pd.notna(filtered_row['JP04a_GL02_03']) else 'N\/A'\r\n            debit_credit_code = filtered_row['JP05a_GL03_04'] if pd.notna(filtered_row['JP05a_GL03_04']) else 'N\/A'\r\n            ledger_account_number = filtered_row['JP13a_BS16_01'] if pd.notna(filtered_row['JP13a_BS16_01']) else 'N\/A'\r\n            ledger_account_name = filtered_row['JP13a_BS16_02'] if pd.notna(filtered_row['JP13a_BS16_02']) else 'N\/A'\r\n            amount = filtered_row['CC05hW_01_target'] if pd.notna(filtered_row['CC05hW_01_target']) else 'N\/A'\r\n\r\n            print(f\"Date: {date}, \"\r\n                  f\"Debit\/Credit Code: {debit_credit_code}, \"\r\n                  f\"Ledger Account Number: {ledger_account_number}, \"\r\n                  f\"Ledger Account Name: {ledger_account_name}, \"\r\n                  f\"Amount: {amount}\")\r\n\r\n        filtered_df = filtered_df.fillna('N\/A')\r\n\r\n        result = filtered_df.groupby(\r\n            ['JP04a_GL02_03_month', 'JP05a_GL03_04', 'JP13a_BS16_01', 'JP13a_BS16_02']\r\n        )['CC05hW_01_target'].sum().reset_index()\r\n\r\n        print(\"\\n6. Intermediate Result:\")\r\n        print(result)\r\n\r\n        results = pd.concat([results, result], ignore_index=True)<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
This section iterates over each unique combination, filters the DataFrame, prints intermediate results, and aggregates the sum of CC05hW_01_target<\/code>.<\/p>\n<\/div>\n
\n
\n
5. Filtered DataFrame for combination (nan, <NA>, nan):\r\nEmpty DataFrame\r\nColumns: [JP04a, JP05a, JP12a, BS04cc, CC03dh_01, JP04a_GL02_01, JP04a_GL02_03, JP04a_GL02_04, GL05c_01, BS15c_01, JP05a_GL03_04, CC05hW_01, JP13a_BS16_01, JP13a_BS16_02, JP12a_01, JP12a_02, JP12a_03, CC05hZ_01, JP01c_BS28_01, JP01c_BS28_02, BS04cc_01, BS04cc_02, BS04cc_03, JP04a_GL02_03_month, CC05hW_01_target]\r\nIndex: []\r\n\r\n5. Filtered DataFrame for combination (D, 150, Receivable Note):\r\n   JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03  ... JP01c_BS28_01   JP01c_BS28_02  BS04cc_01 BS04cc_02  BS04cc_03  JP04a_GL02_03_month CC05hW_01_target\r\n1      1      2      0       0       NaN            NaN    2021-04-25  ...            00  Not Applicable        NaN       NaN        NaN              2021-04         20392404\r\n\r\n[1 rows x 25 columns]\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 150, Ledger Account Name: Receivable Note, Amount: 20392404\r\n\r\n6. Intermediate Result:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01    JP13a_BS16_02  CC05hW_01_target\r\n0             2021-04             D            150  Receivable Note          20392404\r\n\r\n5. Filtered DataFrame for combination (C, 152, Accounts Receivable):\r\n    JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01  ...   JP01c_BS28_02 BS04cc_01  BS04cc_02  BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n3       1      3      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-04          20392404\r\n10      2      3      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-04           2186153\r\n15      2      6      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-04               735\r\n22      3      3      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-04           6636909\r\n27      3      6      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-04               840\r\n\r\n[5 rows x 25 columns]\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 20392404\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 2186153\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 735\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 6636909\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 840\r\n\r\n6. Intermediate Result:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01        JP13a_BS16_02  CC05hW_01_target\r\n0             2021-04             C            152  Accounts Receivable          29217041\r\n\r\n5. Filtered DataFrame for combination (D, 131, Regular Deposit):\r\n    JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01  ...   JP01c_BS28_02 BS04cc_01  BS04cc_02  BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n7       2      2      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-04           2186153\r\n19      3      2      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-04           6636909\r\n\r\n[2 rows x 25 columns]\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 131, Ledger Account Name: Regular Deposit, Amount: 2186153\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 131, Ledger Account Name: Regular Deposit, Amount: 6636909\r\n\r\n6. Intermediate Result:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01    JP13a_BS16_02  CC05hW_01_target\r\n0             2021-04             D            131  Regular Deposit           8823062\r\n\r\n5. Filtered DataFrame for combination (D, 741, Payment Fees):\r\n    JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03  ... JP01c_BS28_01  JP01c_BS28_02  BS04cc_01 BS04cc_02  BS04cc_03  JP04a_GL02_03_month CC05hW_01_target\r\n13      2      5      0       0       NaN            NaN    2021-04-25  ...            Q5   Purchase 10%        NaN       NaN        NaN              2021-04\r\n  735\r\n25      3      5      0       0       NaN            NaN    2021-04-25  ...            Q5   Purchase 10%        NaN       NaN        NaN              2021-04\r\n  840\r\n\r\n[2 rows x 25 columns]\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 741, Ledger Account Name: Payment Fees, Amount: 735\r\nDate: 2021-04-25 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 741, Ledger Account Name: Payment Fees, Amount: 840\r\n\r\n6. Intermediate Result:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n0             2021-04             D            741  Payment Fees              1575\r\n\r\n5. Filtered DataFrame for combination (D, 152, Accounts Receivable):\r\n    JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01  ...   JP01c_BS28_02 BS04cc_01  BS04cc_02  BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n31      4      2      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-05           1245400\r\n36      4      5      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-05           1329984\r\n41      4      8      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-05           3964716\r\n46      4     11      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-05            101952\r\n51      4     14      0       0       NaN            NaN  ...  Not Applicable       NaN        NaN        NaN             2021-05             40800\r\n\r\n[5 rows x 25 columns]\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 1245400\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 1329984\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 3964716\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 101952\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: D, Ledger Account Number: 152, Ledger Account Name: Accounts Receivable, Amount: 40800\r\n\r\n6. Intermediate Result:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01        JP13a_BS16_02  CC05hW_01_target\r\n0             2021-05             D            152  Accounts Receivable           6682852\r\n\r\n5. Filtered DataFrame for combination (C, 511, Sales):\r\n    JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03  ... JP01c_BS28_01  JP01c_BS28_02  BS04cc_01 BS04cc_02  BS04cc_03  JP04a_GL02_03_month CC05hW_01_target\r\n34      4      3      0       0       NaN            NaN    2021-05-31  ...            B5      Sales 10%        NaN       NaN        NaN              2021-05          1245400\r\n39      4      6      0       0       NaN            NaN    2021-05-31  ...            B5      Sales 10%        NaN       NaN        NaN              2021-05          1329984\r\n44      4      9      0       0       NaN            NaN    2021-05-31  ...            B5      Sales 10%        NaN       NaN        NaN              2021-05          3964716\r\n\r\n[3 rows x 25 columns]\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 511, Ledger Account Name: Sales, Amount: 1245400\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 511, Ledger Account Name: Sales, Amount: 1329984\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 511, Ledger Account Name: Sales, Amount: 3964716\r\n\r\n6. Intermediate Result:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n0             2021-05             C            511         Sales           6540100\r\n\r\n5. Filtered DataFrame for combination (C, 521, Sales Returns):\r\n    JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03  ... JP01c_BS28_01  JP01c_BS28_02  BS04cc_01 BS04cc_02  BS04cc_03  JP04a_GL02_03_month CC05hW_01_target\r\n49      4     12      0       0       NaN            NaN    2021-05-31  ...            C5    Revenge 10%        NaN       NaN        NaN              2021-05           101952\r\n54      4     15      0       0       NaN            NaN    2021-05-31  ...            C5    Revenge 10%        NaN       NaN        NaN              2021-05\r\n40800\r\n\r\n[2 rows x 25 columns]\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 521, Ledger Account Name: Sales Returns, Amount: 101952\r\nDate: 2021-05-31 00:00:00, Debit\/Credit Code: C, Ledger Account Number: 521, Ledger Account Name: Sales Returns, Amount: 40800\r\n\r\n6. Intermediate Result:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01  JP13a_BS16_02  CC05hW_01_target\r\n0             2021-05             C            521  Sales Returns            142752<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
\n
3.18. Display Final Results:<\/h3>\n
\n
\n
print(\"\\n7. Final Results DataFrame with Sum by Combination:\")\r\nprint(results)<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
Finally, we display the final results, showing the sum of CC05hW_01_target<\/code> for each combination of JP04a_GL02_03_month<\/code>, JP05a_GL03_04<\/code>, JP13a_BS16_01<\/code>, and JP13a_BS16_02<\/code>.<\/p>\n<\/div>\n
\n
\n
7. Final Results DataFrame with Sum by Combination:\r\n  JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01        JP13a_BS16_02  CC05hW_01_target\r\n0             2021-04             D            150      Receivable Note          20392404\r\n1             2021-04             C            152  Accounts Receivable          29217041\r\n2             2021-04             D            131      Regular Deposit           8823062\r\n3             2021-04             D            741         Payment Fees              1575\r\n4             2021-05             D            152  Accounts Receivable           6682852\r\n5             2021-05             C            511                Sales           6540100\r\n6             2021-05             C            521        Sales Returns            142752<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
By following these steps, we ensure efficient data management in hierarchical tidy data, avoiding redundancy and accurately summarizing financial data.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
4. Conclusion<\/h2>\n
\n
\n
Handling hierarchical tidy data requires careful consideration of how different levels of observation are reported. By merging necessary data into target rows, we can summarize amounts based on debit\/credit codes, account numbers, and months, thereby avoiding redundancy and ensuring efficient data management.<\/p>\n<\/div>\n
\n
The approach outlined in this post demonstrates how to handle such data using Python and pandas, providing a robust solution for financial reporting.<\/p>\n<\/div>\n<\/div>\n<\/div>\n
\n
5. Hierarchical tidy data file<\/h2>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
JP04a<\/p>\n<\/td>\n
\n
JP05a<\/p>\n<\/td>\n
\n
JP12a<\/p>\n<\/td>\n
\n
BS04cc<\/p>\n<\/td>\n
\n
CC03dh_01<\/p>\n<\/td>\n
\n
JP04a_GL02_01<\/p>\n<\/td>\n
\n
JP04a_GL02_03<\/p>\n<\/td>\n
\n
JP04a_GL02_04<\/p>\n<\/td>\n
\n
GL05c_01<\/p>\n<\/td>\n
\n
BS15c_01<\/p>\n<\/td>\n
\n
JP05a_GL03_04<\/p>\n<\/td>\n
\n
CC05hW_01<\/p>\n<\/td>\n
\n
JP13a_BS16_01<\/p>\n<\/td>\n
\n
JP13a_BS16_02<\/p>\n<\/td>\n
\n
JP12a_01<\/p>\n<\/td>\n
\n
JP12a_02<\/p>\n<\/td>\n
\n
JP12a_03<\/p>\n<\/td>\n
\n
CC05hZ_01<\/p>\n<\/td>\n
\n
JP01c_BS28_01<\/p>\n<\/td>\n
\n
JP01c_BS28_02<\/p>\n<\/td>\n
\n
BS04cc_01<\/p>\n<\/td>\n
\n
BS04cc_02<\/p>\n<\/td>\n
\n
BS04cc_03<\/p>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
2021-02-01T13:55:00<\/p>\n<\/td>\n
\n
273.0<\/p>\n<\/td>\n
\n
2021-04-25<\/p>\n<\/td>\n
\n
April 25, Slip No. 201 Imai Department Store<\/p>\n<\/td>\n
\n
1.0<\/p>\n<\/td>\n
\n
21.0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
20392404.0<\/p>\n<\/td>\n
\n
150.0<\/p>\n<\/td>\n
\n
Receivable Note<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
20392404.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
2.0<\/p>\n<\/td>\n
\n
Imai Department Store<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
2021-02-01T13:55:00<\/p>\n<\/td>\n
\n
274.0<\/p>\n<\/td>\n
\n
2021-04-25<\/p>\n<\/td>\n
\n
April 25 Paper NO202 Comprehensive Management Co., Ltd.<\/p>\n<\/td>\n
\n
1.0<\/p>\n<\/td>\n
\n
21.0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
2186153.0<\/p>\n<\/td>\n
\n
131.0<\/p>\n<\/td>\n
\n
Regular Deposit<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
30.0<\/p>\n<\/td>\n
\n
Mii Nagoya<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
2186153.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
7.0<\/p>\n<\/td>\n
\n
Comprehensive management Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
735.0<\/p>\n<\/td>\n
\n
741.0<\/p>\n<\/td>\n
\n
Payment Fees<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
66.0<\/p>\n<\/td>\n
\n
Q5<\/p>\n<\/td>\n
\n
Purchase 10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
30.0<\/p>\n<\/td>\n
\n
Nagoya Branch<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
735.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
7.0<\/p>\n<\/td>\n
\n
Comprehensive management Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
2021-02-01T13:55:00<\/p>\n<\/td>\n
\n
275.0<\/p>\n<\/td>\n
\n
2021-04-25<\/p>\n<\/td>\n
\n
April 25, Slip No. 203, Kobayashi Market Co., Ltd.<\/p>\n<\/td>\n
\n
1.0<\/p>\n<\/td>\n
\n
21.0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
6636909.0<\/p>\n<\/td>\n
\n
131.0<\/p>\n<\/td>\n
\n
Regular Deposit<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
10.0<\/p>\n<\/td>\n
\n
In front of Hokkaido Station<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
6636909.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
25.0<\/p>\n<\/td>\n
\n
Kobayashi Market Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
840.0<\/p>\n<\/td>\n
\n
741.0<\/p>\n<\/td>\n
\n
Payment Fees<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
76.0<\/p>\n<\/td>\n
\n
Q5<\/p>\n<\/td>\n
\n
Purchase 10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
10.0<\/p>\n<\/td>\n
\n
Sapporo Sales Office<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
840.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
25.0<\/p>\n<\/td>\n
\n
Kobayashi Market Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
2021-02-01T13:55:00<\/p>\n<\/td>\n
\n
114.0<\/p>\n<\/td>\n
\n
2021-05-31<\/p>\n<\/td>\n
\n
Sale for May 1st to May 31st<\/p>\n<\/td>\n
\n
1.0<\/p>\n<\/td>\n
\n
21.0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
1245400.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
5.0<\/p>\n<\/td>\n
\n
AABC Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
1245400.0<\/p>\n<\/td>\n
\n
511.0<\/p>\n<\/td>\n
\n
Sales<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
113218.0<\/p>\n<\/td>\n
\n
B5<\/p>\n<\/td>\n
\n
Sales 10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
10.0<\/p>\n<\/td>\n
\n
Sapporo Sales Office<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
1329984.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
14.0<\/p>\n<\/td>\n
\n
Fujita Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
1329984.0<\/p>\n<\/td>\n
\n
511.0<\/p>\n<\/td>\n
\n
Sales<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
120907.0<\/p>\n<\/td>\n
\n
B5<\/p>\n<\/td>\n
\n
Sales 10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
10.0<\/p>\n<\/td>\n
\n
Sapporo Sales Office<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
8<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
3964716.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
8<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
25.0<\/p>\n<\/td>\n
\n
Kobayashi Market Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
8<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
9<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
3964716.0<\/p>\n<\/td>\n
\n
511.0<\/p>\n<\/td>\n
\n
Sales<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
360428.0<\/p>\n<\/td>\n
\n
B5<\/p>\n<\/td>\n
\n
Sales 10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
9<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
10.0<\/p>\n<\/td>\n
\n
Sapporo Sales Office<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
11<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
101952.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
11<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
25.0<\/p>\n<\/td>\n
\n
Kobayashi Market Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
11<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
12<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
101952.0<\/p>\n<\/td>\n
\n
521.0<\/p>\n<\/td>\n
\n
Sales Returns<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
9268.0<\/p>\n<\/td>\n
\n
C5<\/p>\n<\/td>\n
\n
Revenge 10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
12<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
10.0<\/p>\n<\/td>\n
\n
Sapporo Sales Office<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
14<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
40800.0<\/p>\n<\/td>\n
\n
152.0<\/p>\n<\/td>\n
\n
Accounts Receivable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
Not Applicable<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
14<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
5.0<\/p>\n<\/td>\n
\n
AABC Co., Ltd.<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
14<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
0.0<\/p>\n<\/td>\n
\n
Common Department<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
15<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
40800.0<\/p>\n<\/td>\n
\n
521.0<\/p>\n<\/td>\n
\n
Sales Returns<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
3709.0<\/p>\n<\/td>\n
\n
C5<\/p>\n<\/td>\n
\n
Revenge 10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
15<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
10.0<\/p>\n<\/td>\n
\n
Sapporo Sales Office<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
\n
\nLast updated 2024-05-30 16:39:04 +0900\n<\/div>\n<\/div>\n
\n
Contents<\/div>\n