X

Sign Up

or

By signing up I agree to Property Tribes Terms and Conditions


Already a PT member? Log In

Sign Up

Sign Up With Facebook, Twitter, or Google

or


By signing up, I agree to Property Tribes Terms and Conditions


Already a PT member? Log In

Log In

or


Don't have an account? Sign Up

Forgot Password

To reset your password just enter the email address you registered with and we'll send you a link to access a new password.


Already a PT member? Log In

Don't have an account? Sign Up

  • Technology

    QuickBooks price rise. Any alternatives?

     1. Create a "Category" table with the following fields/columns,

    • SubCategory
    • FS SubCategory
    • FS Category

     2. Create a merged table, by combining the "Transaction" table with the "Category" table using "Power Query M" ( Data -> New Query -> From Table Wink  This can be refreshed when needed, via Data ->  Refresh All.

    Here the rows from my Category table..

    SubCategory    FS Sub Cat    FS Cat
    ACCOUNTANCY    Accountancy Fees    PROFIT OR (LOSS) BEFORE TAX
    ADJ REPAIRS FROM CAPITAL    Property Repairs    PROFIT OR (LOSS) BEFORE TAX
    ADJ REPAIRS TO REVENUE    Repairs & Alterations    FIXED ASSETS
    ADMINFEE    Property Income    PROFIT OR (LOSS) BEFORE TAX
    ADVERTISING    Advertising    PROFIT OR (LOSS) BEFORE TAX
    BANK CHARGES    Bank Charges    PROFIT OR (LOSS) BEFORE TAX
    CARPETS    Repairs & Alterations    FIXED ASSETS
    CASH BANK    Cash at Bank    CURRENT ASSETS
    CERT LIC    Certificates & Licences    PROFIT OR (LOSS) BEFORE TAX
    CHARITY    Charity    PROFIT OR (LOSS) BEFORE TAX
    CLEANING    Cleaning     PROFIT OR (LOSS) BEFORE TAX
    CLEANING INC    Property Income    PROFIT OR (LOSS) BEFORE TAX
    COMISSION    Letting Agent Commision    PROFIT OR (LOSS) BEFORE TAX
    COMISSION INC    Property Income    PROFIT OR (LOSS) BEFORE TAX
    CONSUMABLES    Repairs & Renewals    PROFIT OR (LOSS) BEFORE TAX
    COUNCIL TAX    Rent, Rates, Electric etc.    PROFIT OR (LOSS) BEFORE TAX
    DEBTOR    Debtors    CURRENT ASSETS
    DIV    Dividend    DIVIDENDS FOR THE PERIOD
    DIV RECVD    Dividend Received    DIVIDENDS FOR THE PERIOD
    ELEC C    Repairs & Alterations    FIXED ASSETS
    ELEC M    Property Repairs    PROFIT OR (LOSS) BEFORE TAX
    EQUIP EXP    Computer Equipment &  Maint.    PROFIT OR (LOSS) BEFORE TAX
    FINANCE CHARGES    Management/Financial Fees    PROFIT OR (LOSS) BEFORE TAX
    FINE    Legal Fees    PROFIT OR (LOSS) BEFORE TAX
    FIX FIT C    Repairs & Alterations    FIXED ASSETS
    FIX FIT M    Replacement Furniture    PROFIT OR (LOSS) BEFORE TAX
    INSURANCE    General Insurances    PROFIT OR (LOSS) BEFORE TAX
    INTEREST    Loan Interest etc    PROFIT OR (LOSS) BEFORE TAX
    INTEREST C    Loan Interest etc    PROFIT OR (LOSS) BEFORE TAX
    INTERNET    Telephone & Communications    PROFIT OR (LOSS) BEFORE TAX
    LAB C    Repairs & Alterations    FIXED ASSETS
    LAB M    Property Repairs    PROFIT OR (LOSS) BEFORE TAX
    LEGAL COSTS    Legal Fees    PROFIT OR (LOSS) BEFORE TAX
    LIFE ASSURANCE    General Insurances    PROFIT OR (LOSS) BEFORE TAX
    LOAN_AD    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_AP    Director Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    SHARES    Called up share capital    CAPITAL AND RESERVES
    LOAN_C&G    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_CC    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_CC_BC    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_CC_HS    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_CC_LD    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_CC_ST    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_CHT    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_DERBY    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_DH    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_DK    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_DS    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_DYLAN    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_GB    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_GF    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_GT    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_JM    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_LD    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_OTHER    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_PARAGON    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_PB    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_PLUK    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_PLUK_BFS    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_PLUK_CWSCOTT    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_PLUK_KJONES    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_PLUK_PLITTLEMORE    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_TMW    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    LOAN_WLCH    Loans    CREDITORS DUE AFTER MORE THAN ONE YEAR
    MAT C    Repairs & Alterations    FIXED ASSETS
    MAT M    Property Repairs    PROFIT OR (LOSS) BEFORE TAX
    MGMT COST    Stationery & Sundry Expenses    PROFIT OR (LOSS) BEFORE TAX
    PLANNING    Professional    FIXED ASSETS
    PLUMB C    Repairs & Alterations    FIXED ASSETS
    PLUMB M    Property Repairs    PROFIT OR (LOSS) BEFORE TAX
    POSTAGE    Stationery & Sundry Expenses    PROFIT OR (LOSS) BEFORE TAX
    PROF FEE    Professional    FIXED ASSETS
    PURCH    Property    FIXED ASSETS
    RENT    Property Income    PROFIT OR (LOSS) BEFORE TAX
    RENT_QTR    Property Income    PROFIT OR (LOSS) BEFORE TAX
    RENTUC    Property Income    PROFIT OR (LOSS) BEFORE TAX
    REPAIRS    Property Repairs    PROFIT OR (LOSS) BEFORE TAX
    SAL EXP    Wages & Training    PROFIT OR (LOSS) BEFORE TAX
    SALE    Property    FIXED ASSETS
    SDLT    Professional    FIXED ASSETS
    SERV PROV    Services Provided    PROFIT OR (LOSS) BEFORE TAX
    TAX LIAB    Tax    CREDITORS DUE WITHIN ONE YEAR
    TAX P&L    Tax Incurred    TAX
    TEL MOB    Telephone & Communications    PROFIT OR (LOSS) BEFORE TAX
    TRAVEL    Travel Expenses    PROFIT OR (LOSS) BEFORE TAX
    TT LEGAL    Legal Fees    PROFIT OR (LOSS) BEFORE TAX
    TV LICENSE    Certificates & Licences    PROFIT OR (LOSS) BEFORE TAX
    UTILITIES    Rent, Rates, Electric etc.    PROFIT OR (LOSS) BEFORE TAX
    WATER RATES    Rent, Rates, Electric etc.    PROFIT OR (LOSS) BEFORE TAX
    WEAR TEAR    Wear Tear    PROFIT OR (LOSS) BEFORE TAX

    0
    0

    Money Dasbboard is a free app that links to your bank account and you can see your recent transactions. I have found it useful

    0
    0

    Didn’t get on with QuickFile. You have to post an invoice and then allocate a payment against it.

    This makes it a bit faffy. Especially for things like mortgage payments. I’d rather post direct to the gl code and bypass the invoice.

    0
    0