{"id":14023,"date":"2018-05-08T08:33:24","date_gmt":"2018-05-08T08:33:24","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=14023"},"modified":"2020-09-30T12:56:27","modified_gmt":"2020-09-30T12:56:27","slug":"9-1-5-creating-accounting-reports-with-custom-reporting-tags","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/9-1-5-creating-accounting-reports-with-custom-reporting-tags\/","title":{"rendered":"9.1.5. Creating Accounting Reports with Custom Reporting Tags"},"content":{"rendered":"

Creating Accounting Reports with Custom Reporting Tags<\/h1>\n
<\/div>\n

Using Custom Report Tags<\/h2>\n
\n

Custom reports contain some tags useful for preparing reports easily. These tags work same as Printer Template Tags but the difference is these tags will display values from selected date range, or date range from active work period if used out of report module. You can use these tags and SQL together in a single report.<\/p>\n

As an example it’ll be created a sample accounting report. Before doing it some details will be given about how accounting related tags works.<\/p>\n

{ACCOUNT TOTAL:X}<\/strong>
\nThis tag returns total balance of X. X can be an account name or account type name. For example if you type\u00a0{ACCOUNT TOTAL:Cash}<\/code>\u00a0it will give you the balance of ‘Cash’ account. If you type\u00a0{ACCOUNT TOTAL:Payment Accounts}<\/code>\u00a0it will give you the balance total of all ‘Payment Accounts.’<\/p>\n

{ACCOUNT DEBIT TOTAL:X}<\/strong>
\nWorks like\u00a0{ACCOUNT TOTAL:X}<\/code>\u00a0but it gives only Debit Total.<\/p>\n

{ACCOUNT CREDIT TOTAL:X}<\/strong>
\nWorks like\u00a0{ACCOUNT TOTAL:X}<\/code>\u00a0but it gives only Credit Total.<\/p>\n

{ACCOUNT TRANSACTION TOTAL:X}<\/strong>
\nThis tag returns total of X Account Transactions. X should be\u00a0Account Transaction Type Name:Account Name<\/code>. For example\u00a0{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Cash}<\/code>\u00a0tag will return total amount of\u00a0Payment Transactions<\/code>\u00a0which changes\u00a0Cash<\/code>\u00a0account.<\/p>\n

{ACCOUNT TRANSACTION DEBIT TOTAL:X}<\/strong>
\nWorks like\u00a0{ACCOUNT TRANSACTION TOTAL}<\/code>\u00a0but returns Debit Total.<\/p>\n

{ACCOUNT TRANSACTION CREDIT TOTAL:X}<\/strong>
\nWorks like\u00a0{ACCOUNT TRANSACTION TOTAL}<\/code>\u00a0but returns Credit Total.<\/p>\n

{ACCOUNT TRANSACTION DETAILS:X}<\/strong>
\nThis special tag prints Account Transaction Details for X Account Transaction Type. X will be the Account Transaction Name. It returns a 3 column table. Date, Description and Amount. For example:\u00a0{ACCOUNT TRANSACTION DETAILS:Customer Cash Payment:Cash}<\/code>\u00a0tag will print details of cash payments made by customers.<\/p>\n<\/div>\n

Sample Report<\/h3>\n
\n

If you’ve used V2 before you’ll remember\u00a0Cash Drawer Report<\/code>. This custom report creates a\u00a0Cash Drawer Report<\/code>\u00a0in that format.<\/p>\n

Tip;<\/span>\u00a0In this report we assumed you have\u00a0Cash Expense<\/code>\u00a0and\u00a0Cash Income<\/code>\u00a0accounts. Please update income and expense account names in report template to match it to your account and account type names.<\/p>\n\n\n\n
[Expenses:1,2,1]
\n>Cash Transactions||
\n{ACCOUNT TRANSACTION DETAILS:Cash Expense:Cash}
\nTotal||{ACCOUNT TRANSACTION TOTAL:Cash Expense:Cash}<\/code><\/p>\n

[Incomes:1,2,1]
\n>Sale Incomes||
\nCash||{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Cash}
\nCredit Card||{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Credit Card}
\nTotal||{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Payment Accounts}
\n>Cash Transactions||
\n{ACCOUNT TRANSACTION DETAILS:Cash Income:Cash}
\n{ACCOUNT TRANSACTION DETAILS:Customer Cash Payment:Cash}
\nTotal||[=F((TN('{ACCOUNT TRANSACTION TOTAL:Cash Income:Cash}')+TN('{ACCOUNT TRANSACTION TOTAL:Customer Cash Payment:Cash}')),'#,#0.00')]
\n>Income Totals||
\nCash||{ACCOUNT DEBIT TOTAL:Cash}
\nCredit Card||{ACCOUNT DEBIT TOTAL:Credit Card}<\/code><\/p>\n

[Totals:3,1]
\nCash|{ACCOUNT TOTAL:Cash}
\nCredit Card|{ACCOUNT TOTAL:Credit Card}
\nTotal|{ACCOUNT TOTAL:Payment Accounts}<\/code><\/td>\n

<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/code><\/code><\/p>\n

<\/code><\/code>\"\"By using this template you can create a report like this. You’ll notice that you can use some printer template functions such as\u00a0TN<\/code>\u00a0F<\/code>\u00a0or expressions.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Creating Accounting Reports with Custom Reporting Tags Using Custom Report Tags Custom reports contain some tags useful for preparing reports easily. These tags work same as Printer Template Tags but the difference is these tags will display values from selected date range, or date range from active work period if used out of report module. […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-14023","post","type-post","status-publish","format-standard","hentry","category-reports"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=14023"}],"version-history":[{"count":10,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14023\/revisions"}],"predecessor-version":[{"id":25069,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14023\/revisions\/25069"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=14023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=14023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=14023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}