An Introduction to SQL-Ledger

Description

I SQL-Ledger and Business Processes Introduction to SQL-Ledger Why SQL-Ledger Advantages of SQL-Ledger Key Features Limitations of SQL-Ledger System Requirements of SQL-Ledger User Account and Database Administration Basics Companies and Datasets How to Create a User Permissions User Account Types Other Features Chart of Accounts Introduction to Double Entry Bookkeeping Account Types Debits and Credits A few Examples General Guidelines on Numbering Accounts Adding/Modifying Accounts Listing Account Balances and Transactions Administration Taxes, Defaults, and Preferences Adding A Sales Tax Account Setting a Sales Tax Amount Default Account Setup Currency Setup Sequence Settings Audit Control Explaining transaction reversal Close books option Audit Trails Departments Cost v Profit Centers. Warehouses Languages Types of Businesses Misc. GIFI SIC Overview of Template Editing Year-end Options in the sql-ledger.conf Goods and Services Basic Terms The Price Matrix Pricegroups Groups Labor/Overhead Services Shipping and Handling as a Service Parts Assemblies and Manufacturing Stocking Assemblies Reporting All Items and Parts Reports Requirements Services and Labor Assemblies Groups and Pricegroups Translations How Cost of Goods Sold is tracked AP Basic AP Concepts Vendors AP Transactions AP Invoices Correcting an AP Invoice Cash payment And Check Printing Rapid Payment Entry Screen Transaction/Invoice Reporting Transactions Report Outstanding Report AP Aging Report Tax Paid and Non-taxable Report Vendor Reporting Vendor Search Vendor History AR Customers Customer Price Matrix AR Transactions AR Invoices Cash Receipt Cash Receipts for multiple customers AR Transaction Reporting AR Transactions Report AR Aging Report Customer Reporting Projects Project Basics Timecards Projects and Invoices Reporting Timecard Reporting Project Transaction Reporting List of Projects Possibilities for Using Projects Quotations and Order Management Sales Orders Quotations Shipping AR Work Flow Service Example Single Warehouse Example Multiple Warehouse Example Requests for Quotation (RFQ) Purchase Orders Receiving AP Work Flow Bookkeeper entering the received items, order completed in full Bookkeeper entering received items, order completed in part Receiving staff entering items Generation and Consolidation Generation Consolidation Reporting Shipping Module: Transferring Inventory between Warehouses HR POS Sales Screen Possibilities for Data Entry Hardware Support Reports Open Invoices Receipts General Ledger GL Basics Paper-based accounting systems and the GL Double Entry Examples on Paper The GL in SQL-Ledger Cash Transfer GL Transactions Payroll as a GL transaction Reconciliation Reports GL as access to almost everything else Recurring Transactions Financial Statements and Reports Cash v. Accrual Basis Viewing the Chart of Accounts and Transactions Trial Balance The Paper-based function of a Trial Balance Running the Trial Balance Report What if the Trial Balance doesn't Balance? Trial Balance as a Summary of Account Activity Trial Balance as a Budget Planning Tool Income Statement Uses of an Income Statement Balance Sheet What if the Balance Sheet doesn't balance? No Statement of Owner Equity? The Template System Text Templates HTML Templates LaTeX Templates What is LaTeX ? Using LyX to Edit LaTeX Templates Customizing Logos How are They Stored in the Filesystem? Upgrade Issues II Technical Overview Basic Architecture The Software Stack Capacity Planning Scalability Strategies Database Maintenance Known issues Customization Possibilities Brief Guide to the Source Code Data Entry Screens Examples Extensions Examples Templates Examples Reports Examples Integration Possibilities Reporting Tools Examples Line of Business Tools on PostgreSQL Known Issues Strategies Examples Line of Business Tools on other RDBMS's Strategies Integration Products and Open Source Projects Customization Guide General Information Customizing Templates Page Breaks in LaTeX Conditionals Loops File Inclusion Cross-referencing and multiple passes of LaTeX Variable Substitution Customizing Forms Customizing Modules Database Access Examples Adding a New Report for Sales Data Truncating Number of Invoices on a Check Stub Adding the a Check ID flag for Alcohol Purchases III Appendix Where to Go for More Information Glossary GNU Free Documentation License 1. APPLICABILITY AND DEFINITIONS 2. VERBATIM COPYING 3. COPYING IN QUANTITY 4. MODIFICATIONS 5. COMBINING DOCUMENTS 6. COLLECTIONS OF DOCUMENTS 7. AGGREGATION WITH INDEPENDENT WORKS 8. TRANSLATION 9. TERMINATION 10. FUTURE REVISIONS OF THIS LICENSE ADDENDUM: How to use this License for your documents