You’re offline. This is a read only version of the page.
Announcements
23
I am trying to build an account schedule that lists all accounts (balance sheet and income statement posting accounts) in the rows with 2 columns - 1 to display debit account balances and the 2 to display credit account balances.
By using the Amount Type to be Debit Amounts for Column 1 and Credit Amounts for Column 2 - this just produces a results balances for both columns if the account has both debit and credit transactions.
By using the Amount Type - Net Amount and then for Column 1 (Debit) show When Positive and for Column 2 (Credit) show when Negative - this produces the required result for each account row.
The problem then is the final row I want to display a total for the column - it displays zero balance as its the full Trial Balance - display the total as zero.
Snapshot of the output trying to be achieved
| Account Code | Account | Account Type | Debit | Credit |
| 200 | Fixed Revenue | Revenue | 870,092.57 | |
| 201 | Deliverables | Sales | 325,845.66 | |
| 202 | Workforce Planning | Sales | 2,120,150.01 | |
| 203 | Communications | Sales | 2,246,378.90 | |
| 204 | Skilling | Sales | 1,555,038.16 | |
| 205 | Admin | Sales | 1,089,784.00 | |
| 207 | Reimburseable Income | Sales | 417,236.29 | |
| 208 | Talent Acquisition | Sales | 532,201.08 | |
| Total | 13,814,195.65 | 13,814,195.65 |
Stephen,
If you want me to try to massage to what the client needs, feel free to attach the Account Schedule layout and Column Layout and I can play with it in my database.
Thanks,
Steve
It put the split based on transaction not balance which is not what customer needed. Thank you.
It does have the components just not the look and feel customer required
Stephen,
Here is my image of an Account Schedule that takes multiple rows and shows the Debit and Credit columns and summarizes at the end. Just to clarify one thing, you are creating a total for the Debit and Credit column so they will not equal. You could add a 3rd column the nets the 2 together, like my example.
As Josh noted, the Trial Balance could work here too.
Hope this helps.
Thanks,
Steve
#1
André Arnaud de Cal...
293,309
Super User 2025 Season 1
#2
Martin Dráb
232,162
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
