The ACCOUNTTOTALDEBITS function calculates the total debits of one or more general ledger account(s) for a given period.
ACCOUNTTOTALDEBITS(Connection, Ledger, AccountClass, Account,
Subaccount, Branch, From, To, IncludeUnposted)
The name of the connection, as specified in the Connection Manager
Ledger to use in the calculation.
Optional, though required if Account is empty
The account class to use for the calculation.
Optional, though required if AccountClass is empty
The general ledger account(s) to use for the calculation.
The general ledger subaccounts(s) to include.
The branch(es) to include.
Beginning of the financial period, in MM-YYYY format
Cell reference to the beginning date
End of the financial period, in MM-YYYY format.
Cell reference to the ending date
1 - Include posted transactions only (default)
2 - Include Unposted transactions only
3 - Include Posted and Unposted transactions*
(note: Transactions with a status of "On Hold" are excluded. When Unposted transactions are included, the following two statuses are included: Balanced, Unposted).
Excel for Windows allows the use of quotation marks around this parameter. Excel for Mac and Excel Online require that it be unquoted.
Based on this data:
Example #1 (using Financial Period)
=ACCOUNTTOTALDEBITS("Demo", "ACTUAL", , "10200",, "PRODWHOLE", $F$1,
Description: Calculates the total debits posted in general ledger account #10200 of the PRODWHOLE branch during the period of 01-2019.
Example #2 (using cell references to dates)
=ACCOUNTTOTALDEBITS("Demo", "ACTUAL" , , $B7 , , , $C$4, $D$4)
Description: Calculates the total debits posted in general ledger account #10600 (as noted in cell B7) between January 1, 2019 and January 15, 2019 (as noted in cells C4 and D4).
Limitations to filtering by date instead of financial period: