Template:Profit and loss for

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
 
Line 41: Line 41:
       acc.Super,
       acc.Super,
       acc.Name,
       acc.Name,
-
       COALESCE(SUM(CASE WHEN x.type = 0 THEN Amount END), 0) AS Debits,
+
       COALESCE(SUM(CASE WHEN x.type = 1 THEN Amount END), 0) AS Debits,
-
       COALESCE(SUM(CASE WHEN x.type = 1 THEN Amount END), 0) AS Credits,
+
       COALESCE(SUM(CASE WHEN x.type = 0 THEN Amount END), 0) AS Credits,
       COALESCE(SUM(Amount), 0) AS Net
       COALESCE(SUM(Amount), 0) AS Net
   FROM sa_accounts acc
   FROM sa_accounts acc

Latest revision as of 07:20, 18 May 2020

Usage

Display a generally accepted accounting practices (GAAP) "P&L" statement for the indicated time period.

Parameters

  1. A four-character year for an annual report, or a year-month for a monthly report.

Work Plan

  • Complete entry of test data.
  • Classify our internal general journal entries in terms of GAAP accepted P&L categories.
  • Generate and display the proper roll-ups.
  • Test and compare to PDF P&L statements until they agree.
  • Re-generate and upload new PDF statements.

Example

as entered 
{{profit and loss for|2015-08}}
as displayed 
This information is only available to logged-in users. Please log in or ask for an account to see this information.

See also

Template

Share your opinion


blog comments powered by Disqus
Personal tools
Get our newsletter!
Name:
Email Address:

disturbance
entry points
help (off site)
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro