C:\Users\iwill\OneDrive\BYU Winter 2023\ACC 591R\Challenges\Monthly Challange 1\ChallangeX_Willyerd_Isaac\ChallangeMX_September_Journal_Data.xlsx|||`General Journal$` False 1 ChallangeMX_September_Journal_Data.xlsx Query=`General Journal$` C:\Users\iwill\OneDrive\BYU Winter 2023\ACC 591R\Challenges\Monthly Challange 1\ChallangeX_Willyerd_Isaac\ChallangeMX_September_Journal_Data.xlsx|||`Beginning Balances$` False 1 Reads in Beginning Balances ChallangeMX_September_Journal_Data.xlsx Query=`Beginning Balances$` Sum's Debits and Credits by Account Sum's Debits and Credits by Account Renames Columns Renames Columns Sorts by Account for Visual Examination Acct - Ascending Simple >= Acct True fixed 2023-03-06 11:08:04 0 4000 2023-03-06 11:08:04 2023-03-06 11:08:04 [Acct] >= 4000 Simple >= Acct True fixed 2023-03-06 11:11:21 0 6000 2023-03-06 11:11:21 2023-03-06 11:11:21 [Acct] >= 6000 Sums Total DR and CR for Expenses Sums Total DR and CR for Expenses Sums total DR and CR for Revenues Sums total DR and CR for Revenues Error Combines Total Revenues and Expense Fields Combines Total Revenues and Expense Fields Calculates Total "Retained Earnings" to add to Owners Equity Simple IsNotNull Acct True fixed 2023-03-06 11:23:56 0 2023-03-06 11:23:56 2023-03-06 11:23:56 !IsNull([Acct]) False False "Acct","DR","CR" False True True False False False False False False upper Inputs 0 into DR and CR fields where Null Inputs 0 into DR and CR fields where Null Simple IsNotNull Acct True fixed 2023-03-06 11:56:45 0 2023-03-06 11:56:44 2023-03-06 11:56:44 Filters out Null Acct's !IsNull([Acct]) 3700 Inputs Account for Owners Equity Inputs Account for Owners Equity Error Adds Account for Joining Adds Account for Joining Changes Field Order Changes Field Order Selects Needed Fields and changes DR Balances to Fixed Decimal 19.2 to set to two decimal places Selects Needed Fields Warning All ByName Adds Changed to Owners Equity through Income Statement Accounts Summarized Before Adds Changed to Owners Equity through Income Statement Accounts Summarized Before Renames Field DR Balance Field Renames Field DR Balance Field Changes Acct Field to Int32 to facilitate Joining Changes Acct Field to Int32 to facilitate Joining Joins Beginning Balances and the summarized Journal Entries by Account Joins Beginning Balances and the summarized Journal Entries by Account Adds DR Balance Field for Accounts with no Journal Entries ByPos Warning All ManualDelayed Union's two sets of Accounts, ones that had Journal Entries, and ones who didn't (R Output from Join Tool) This tool uses Manually Configured Fields Union's two sets of Accounts, ones that had Journal Entries, and ones who didn't (R Output from Join Tool) This tool uses Manually Configured Fields Acct - Ascending Calculates an Ending Balance Field to compare to given amounts C:\Users\iwill\OneDrive\BYU Winter 2023\ACC 591R\Challenges\Monthly Challange 1\ChallangeX_Willyerd_Isaac\ChallangeMX_September_Journal_Data.xlsx|||`Ending Balances$` False 1 Reads in Given Ending Balances for the Accounts ChallangeMX_September_Journal_Data.xlsx Query=`Ending Balances$` Filters out Null Fields Filters out Null Fields Joins and Renames Fields to compare given amounts to calculated amounts from the Journal Entries Joins and Renames Fields to compare given amounts to calculated amounts from the Journal Entries Sorts by Account Acct - Ascending [EndingDebitBalances_Calculated] != [EndingBalances_Given] Custom Filters for the accounts [EndingDebitBalances_Calculated] != [EndingBalances_Given] Selects only necessary columns Selects only necessary columns C:\Users\iwill\AppData\Local\Temp\Engine_21684_4cebd7c8f1ef9f408c43a2acf30753f3_\Engine_21684_ae247dcf4677ae45a0188c948bbc288d~.yxdb Single Profile Classifies each Account as an Asset, Liability, etc. Account Type = IF [Acct] < 3000 THEN "Asset" ELSEIF Acct >= 3000 and [Acct]<369... Sums by Account Type to Test if DR = CR Sums by Account Type to Test if DR = CR Creates a Sum for the Total Row Creates a Sum for the Total Row Total Inputs another Field to Join on then create a Union Inputs another Field to Join on then create a Union Error Appends Total Label to Total Line Appends Total Label to Total Line Warning All ByPos Adds Total Line Adds Total Line C:\Users\iwill\AppData\Local\Temp\Engine_21684_4cebd7c8f1ef9f408c43a2acf30753f3_\Engine_21684_1f5d8a9a051a45409f8be1c532b67290~.yxdb Horizontal New Workflow7