Overview
The MTD Quarterly Returns - Landlord UK Property import option allows BrightBooks users managing UK property rental businesses to efficiently upload complete quarterly income and expense journals directly from Excel. This eliminates manual journal entries, ensures all figures align with HMRC submissions, and maintains a robust audit trail for compliance.
Step 1: Select Import Template
- Go to Settings > Data > Imports.
- From the list of available import templates, locate "MTDfIT Quarterly Returns - Landlord UK Property".
- Select it and click Next.
Step 2: Prepare Excel File
- Ensure your Excel template follows the required format with a ‘BB Journals’ tab.
-
Rows to include depend on the quarter you are importing:
- Q1: Rows 1–19
- Q2: Rows 1–38
- Q3: Rows 1–57
- Q4: Rows 1–76
- Skip any journal entries where both Debit and Credit are zero (these rows are ignored automatically).
- Do not modify or rely on "Nominal Description" and "MTD Group" columns.
- Include Disallowed values in column I (positive debits / negative credits).
Step 3: Upload and Validate File
- Select Tax Year, Quarter, and upload your Excel file.
- The Import button will become active once all required inputs are provided.
- Click Import to proceed.
Step 4: Import Processing Logic
Upon confirmation:
- The system validates the uploaded file per the quarter selected.
- Journal entries are matched and processed according to ExternalRef flags unique to each quarter and tax year, e.g.,
MTDITLUKPCQ1[YY/Y]for Q1. - Journals with equal debit and credit of zero are ignored.
- Journals must balance (debits = credits).
- The system performs differential checks to update only changed entries, preserving existing Notes unless newly created.
- Import IDs are assigned in the format:
IMP_[YYYYMMDD]_[HHmm]_[sequence]for traceability. - Original file is stored immutably with timestamp and Import ID for audit purposes.
Quarter Specific Details:
Quarter |
Rows Read |
Check Previous Quarter's Journals |
ExternalRef Flag Example |
Notes Text Example |
|---|---|---|---|---|
Q1 |
1-19 |
N/A |
MTDITLUKPCQ1[YY/Y] |
MTDfITLandlordUKProperty [TaxYear] Q1 Import |
Q2 |
1-38 |
Checks Q1 journals |
MTDITLUKPCQ2[YY/Y] |
MTDfITLandlordUKProperty [TaxYear] Q2 Import |
Q3 |
1-57 |
Checks Q2 journals |
MTDITLUKPCQ3[YY/Y] |
MTDfITLandlordUKProperty [TaxYear] Q3 Import |
Q4 |
1-76 |
Checks Q3 journals |
MTDITLUKPCQ4[YY/Y] |
MTDfITLandlordUKProperty [TaxYear] Q4 Import |
- When importing Q2, the system verifies Q1 entries and zeroes missing ones to 0.00 (and similarly for Q3 and Q4 checking prior quarters).
- Only modified journals have their "Last Modified By Import ID" updated.
Step 5: Review Imported Journals
- When viewing any imported MTDfIT landlord property journal in BrightBooks:
- A paperclip icon appears indicating attachment to an import.
- Clicking the icon reveals:
- Source filename and timestamp
- Import ID
- Download link for the original uploaded Excel file
- Import history with creation date/Import ID, last updated date/Import ID (if applicable)
FAQ and Important Notes
Q: Can I import quarters out of order?
A: Yes, the system supports flexible import order. Diff-detection logic ensures audit integrity without false updates.
Q: What happens if I make manual adjustments after importing?
A: This is not recommended and breaks compliance. Use this import only once your Excel data is final and complete.
Q: Can users edit the Notes field?
A: Yes, users may edit Notes without impacting transaction matching—matching is done purely on the ExternalRef field.
Q: What about audit trail and compliance?
A: All source files are stored immutably to provide a full audit trail for HMRC inspection.
If you need further assistance, please contact BrightBooks Support.