The ACCOUNTTOTALCREDITS function calculates the total credits of one or more general ledger account(s) over a given period.
ACCOUNTTOTALCREDITS(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:
=ACCOUNTTOTALCREDITS("Demo", "ACTUAL", , "10200", , "01-2019", "01-2019")
Description: Calculates the total posted credits of General Ledger account #10200 (as noted in cell B6) during the first financial period of the year 2019 (as noted in cell G1).
=ACCOUNTTOTALCREDITS("Demo", "ACTUAL", , "11000", , $C$4, $D$4,3)
Description: Calculates the combined total of the posted and unposted credits of General Ledger account #11000 (as noted in cell B10) between January 1, 2019 (as noted in cell C4) and January 15, 2019 (as noted in cell D4).
Limitations to filtering by date instead of financial period: