UK Accounting & Tax

🚀 Key Benefits of Standalone Operation

• No dependencies on Dolibarr's company/societe table
• Independent client management - clients exist only in this module
• Self-contained database schema with all necessary tables
• No interference with existing Dolibarr data
• Perfect for accounting practices managing multiple clients

Features

• Client Management: Add and manage clients with their tax details
• VAT Returns: Generate and manage VAT returns for each client
• Tax Returns: Create and manage self-assessment tax returns
• Bookkeeping: Track income and expenses with VAT calculations
• PDF Reports: Generate comprehensive PDF reports for all data
• Standalone Operation: Works independently from Dolibarr companies

Installation

1. Ensure the module is properly installed in your Dolibarr custom directory
2. Run the database migration script if needed (see Database Setup below)
3. Configure permissions for users who will access the module

Database Setup

Fresh Installation

The module will automatically create the necessary database tables during installation.

Migration from Company-Linked Version

If you have an existing installation that linked to Dolibarr companies:

1. Backup your database first!
2. Run the migration script: sql/mysql/migrate_to_standalone.sql
3. This will:
   • Create backup tables of your existing data
   • Migrate client names from company names
   • Remove all company dependencies
   • Create new standalone tables

Database Fix (Legacy)

If you encounter "Unknown column 'client_name'" errors, run the database fix:

1. Go to Setup → Tools → SQL Query
2. Copy and paste the contents of sql/mysql/fix_client_name.sql
3. Click Execute

Getting Started

1. Client Management

Adding a New Client

1. Navigate to UK Accounting Tax → Clients

2. Click New Client

3. Fill in the required information:

   • Client Name: Full name of the client or business
   • Client Type: Select "Company" or "Self-employed"
   • VAT Number: VAT registration number (format: GB123456789)
   • UTR Number: Unique Taxpayer Reference number
   • Accounting Period Start/End: Financial year dates
   • VAT Registration Date: When VAT registration became effective
   • VAT Deregistration Date: When VAT registration was cancelled (if applicable)
   • Status: Active or Inactive
   • Note: Any additional information

4. Click Create to save the client

Editing a Client

1. Go to Clients list
2. Click on the client name or the edit icon
3. Modify the required fields
4. Click Save to update

Client Card Features

• View all client information
• Access linked VAT returns and tax returns
• View bookkeeping transactions
• Generate PDF reports for the client

2. VAT Returns

Creating a VAT Return

1. Navigate to UK Accounting Tax → VAT Returns

2. Click New VAT Return

3. Select the client from the dropdown

4. Set the period start and end dates

5. Fill in the VAT boxes:

   • Box 1: VAT due on sales
   • Box 2: VAT due on acquisitions from EC
   • Box 3: Total VAT due
   • Box 4: VAT reclaimed on purchases
   • Box 5: Net VAT to pay/reclaim
   • Box 6: Total value of sales
   • Box 7: Total value of purchases
   • Box 8: Total value of goods supplied to EC
   • Box 9: Total value of acquisitions from EC

6. Set the due date and status

7. Click Create to save

VAT Return Status

• Draft: Initial state, can be modified
• Submitted: Sent to HMRC
• Accepted: Accepted by HMRC
• Rejected: Rejected by HMRC

Generating VAT Return PDF

1. Open the VAT return card
2. Click Generate PDF button
3. The PDF will download automatically

3. Tax Returns

Creating a Tax Return

1. Navigate to UK Accounting Tax → Tax Returns

2. Click New Tax Return

3. Select the client and tax year

4. Set the period start and end dates

5. Fill in the income and expenses:

   • Trading Income: Income from business activities
   • Other Income: Additional income sources
   • Allowable Expenses: Business expenses
   • Personal Allowance: Personal tax allowance
   • National Insurance: NI contributions

6. The system will calculate:

   • Total income
   • Net profit
   • Taxable income
   • Tax due
   • Total tax due

7. Click Create to save

Tax Return Status

• Draft: Initial state, can be modified
• Submitted: Sent to HMRC
• Accepted: Accepted by HMRC
• Rejected: Rejected by HMRC

4. Bookkeeping

Adding Transactions

1. Navigate to UK Accounting Tax → Bookkeeping

2. Click New Transaction

3. Select the client

4. Fill in the transaction details:

   • Date: Transaction date
   • Type: Income or Expense
   • Description: Transaction description
   • Category: Transaction category
   • Amount: Total amount including VAT
   • VAT Rate: Applicable VAT rate
   • Note: Additional information

5. The system will automatically calculate:

   • VAT amount
   • Net amount

6. Click Create to save

VAT Rates

The system supports standard UK VAT rates:

• 0%: Zero-rated goods and services
• 5%: Reduced rate (e.g., energy-saving materials)
• 20%: Standard rate (most goods and services)
• Exempt: VAT-exempt transactions

Viewing Transactions

• Use the bookkeeping list to view all transactions
• Filter by client, date range, or transaction type
• Export to PDF for reporting

5. Reports

Generating Reports

1. Navigate to UK Accounting Tax → Reports
2. Choose from two options:

Custom Report Form

1. Select a client (required)
2. Choose report type:
   • Client Summary Report: Basic client information
   • Client Bookkeeping Report: All transactions for the client
   • Client VAT Returns Report: All VAT returns for the client
   • Client Tax Returns Report: All tax returns for the client
   • Client Comprehensive Report: Complete overview including all data
3. Set date range (optional)
4. Click Generate PDF

Quick Reports

• Click any button in the quick reports section
• Instantly generate specific reports for each client
• No form filling required

Report Types

Client Summary Report

• Basic client information
• Contact details and tax numbers
• Registration dates and status

Client Bookkeeping Report

• All income and expense transactions
• VAT calculations and summaries
• Net profit/loss calculation

Client VAT Returns Report

• List of all VAT returns
• Periods and amounts due
• Status of each return

Client Tax Returns Report

• List of all tax returns
• Tax years and amounts due
• Status of each return

Client Comprehensive Report

• Complete overview of all client data
• Summary, bookkeeping, VAT returns, and tax returns
• Perfect for client meetings or annual reviews

PDF Generation

All reports are generated as professional PDF documents with:

• Company branding (ScriptStudio)
• Professional formatting
• Detailed tables and summaries
• Automatic calculations
• Date and time stamps

Permissions

The module includes several permission levels:

• Read: View all data
• Write: Create and modify data
• Delete: Remove data
• VAT: Generate and submit VAT returns
• Tax: Generate and submit tax returns

Configure permissions in Setup → Users & Groups → Permissions

Troubleshooting

Common Issues

"Unknown column 'client_name'" Error

• Run the database fix script (see Database Setup above)

"TCPDF not found" Error

• This has been fixed in the latest version
• If you still see this error, contact support

PDF Generation Fails

• Ensure you have write permissions to the output directory
• Check that the client has data to report

Access Denied Errors

• Verify user permissions are set correctly
• Check that the user has access to the UK Accounting Tax module

Support

For technical support or questions about this module, please contact:

ScriptStudio

• Email: [Your support email]
• Website: [Your website]
• Phone: [Your phone number]

Version History

Version 1.6.0 - Complete Standalone Conversion

• Removed all dependencies on Dolibarr's company/societe table
• Independent client management with standalone client_name field
• Updated database schema with no external foreign keys
• Migration script for existing installations
• Enhanced performance with optimized indexes

Version 1.5.0

• Enhanced report cards and PDF generation buttons
• Added client name display and search functionality

Version 1.4.0

• Added client name display and search functionality

Version 1.3.0

• Improved UI and fixed permission issues

Version 1.2.0

• Added PDF report generation

Version 1.1.0

• Added bookkeeping functionality

Version 1.0.0

• Initial release
• Client management
• VAT returns
• Tax returns
• Bookkeeping
• PDF reports
• Standalone operation

License

This module is developed by ScriptStudio and is provided under the same license as Dolibarr.