<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Alexander on Medium]]></title>
        <description><![CDATA[Stories by Alexander on Medium]]></description>
        <link>https://medium.com/@alexander_54590?source=rss-75d5b1eafff5------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*Qkjiq5EWzLl6V9P1</url>
            <title>Stories by Alexander on Medium</title>
            <link>https://medium.com/@alexander_54590?source=rss-75d5b1eafff5------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 00:31:09 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@alexander_54590/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Logging Expenses to Hnry via Email]]></title>
            <link>https://medium.com/@alexander_54590/logging-expenses-to-hnry-via-email-a57cd9c314d5?source=rss-75d5b1eafff5------2</link>
            <guid isPermaLink="false">https://medium.com/p/a57cd9c314d5</guid>
            <category><![CDATA[accounting-software]]></category>
            <category><![CDATA[zapier]]></category>
            <category><![CDATA[hnry]]></category>
            <category><![CDATA[accounting]]></category>
            <category><![CDATA[expenses]]></category>
            <dc:creator><![CDATA[Alexander]]></dc:creator>
            <pubDate>Thu, 17 Aug 2023 03:56:11 GMT</pubDate>
            <atom:updated>2023-08-17T03:56:11.667Z</atom:updated>
            <content:encoded><![CDATA[<p>Like many sole traders, I struggle to keep on top of logging my expenses, I have switched from other accounting applications in the past that make use of bank feeds, however bank feeds did not fix the source of my issue, my own accountability to keep on top of logging them correctly.</p><p><a href="http://hnry.co.nz/">Hnry</a> solves many of my issues by making accounting simple to understand, however hnry had one thing missing, bank feeds/email expenses. This is how I solved my problem.</p><h3>Zapier</h3><p>I noticed <a href="http://hnry.co.nz/">Hnry</a> had zapier intergration, so I created a free account at zapier.com and created my “Zap”</p><p><a href="https://zapier.com/shared/19c4fe5d087857b2971be34ac7c7818eb02ad0ee">Expenses to Hnry - Attachments</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eBBGdma80cZVyTCM6YAcwg.png" /><figcaption>Zaiper Steps</figcaption></figure><p>The “Zap” above has 2 steps<br>1. Wait and Receive mail at the newly generated “<a href="/service/mailto:krispyexpenses.hruu99@zapiermail.com">@zapiermail.com</a>” address<br>2. Add the .PDF atachment as a expense in Hnry.</p><p>This means I could forward my expenses to my example@zapiermail.com email and it would appear in Hnry as “A new Expense via Zapier”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VwOPDZIAX5vfnzs-crx5ew.png" /><figcaption>A new Expense being added into Hnry by Zapier</figcaption></figure><h3>One part of the Puzzle…</h3><p>Zapier only solves one part of my puzzle, this only fixed expense emails with a .PDF attachment, what about screenshots in the email body? or supliers like Spark who dont attach a PDF and make you “login” to download a PDF, the email body still contains enough information to raise an expense.</p><h3>PDFConvert.me</h3><p>Along comes <a href="https://pdfconvert.me/">PDFconvert.me</a> <br>This is a service that allows you to forward it an email, it will convert the body of the email to a PDF and send it back to you with the PDF attached.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*koKqofAS03JwmQfB1pdW8A.png" /><figcaption>Example of a reply from PDFConvert.me</figcaption></figure><p>Now to get some smarts behind this to process emails correctly.</p><p>The steps below are suitable for Outlook/Office365 Mail clients, however this could easily be applied to Gmail/Google Workspace Mail using Filters.</p><h3>Outlook / Office365 Rules</h3><p>I setup a shared mailbox with my Office365 Subscription, called expenses@mydomain.com, giving me a suitable location to forward any expenses I receive too.</p><p>Next I created a new Outlook Rule.</p><p>This rule has 3 key Criteria.<br>1. Apply rule to All messages<br>2. Forward message to pdfconvert@pdfconvert.me<br>3. Exception if the email already contains an attachment<br>This means any expenses that have no PDF/Image Attached to the email will be forwarded to the PDF converter, however anything with an attachment will be left alone.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*h2ozs76I69MbGgg1K2oMjg.png" /><figcaption>The first outlook rule.</figcaption></figure><p>The second Rule</p><p>This rule is for any mail that has an attachment, if it does, it forwards it to my generated@zapiermail.com email address, which is then processed by Zapier and raised in Hnry.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*S7lr-hAusuIWPRiSgjk53A.png" /><figcaption>The second outlook rule</figcaption></figure><h3>Results</h3><p>As shown before, a new expense will appear. However now, expenses will always have a image attached, despite it having a PDF attached or not in the first instance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VwOPDZIAX5vfnzs-crx5ew.png" /><figcaption>A new Expense being added into Hnry by Zapier</figcaption></figure><p>Below is a expense that would of not normally been able to be imported directly into Hnry. A Spark Bill that does not contain a PDF.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QxHcoJSMTArcCwlbe0kOJQ.png" /><figcaption>Example of a Spark bill that does not have an attachment.</figcaption></figure><p>Keep in mind however, as of writing this article, the only information that is able to be imported via Zapier is the atachment itself.</p><p>I have been in contact with the Hnry support team to see if there is any additional work they can put into the Zapier integration to allow other details to come through, such as the subject line as a description, or if they could apply automatic screen reading to the contents of the bill to search for the words “Date, Total, GST” etc to populate these fields automatically like other applications. I feel this feature will come in time.</p><h3>Screenshots and Photos</h3><p>I often forget to get a recipt, or sometimes have to pay for something directly via bank transfer. One way to fix this is by uploading a screenshot to Hnry, however the tools used in this article apply the same to screenshots.</p><p>I just simply take a screenshot of the bank transaction, and email myself to my “expenses@mydomain.com” account, and the rules do the rest. After 30 seconds, its ready to go in Hnry.</p><h3>Taking this a step further — Automatic Rules</h3><p>If your like me, then you want to be spending as little time as possible managing your expenses, and more time on other tasks. This is where more rules come into play.</p><p>A lot of my bills are sent directly into my work mailbox, however some bills like Home office Rent, Power, Water, Internet are still sent to my personal email.</p><p>This is where rules come into play. No matter what mailbox or account your bills are received into, you can create forwarding rules based on search criteria.</p><p>For example, my mobile bill is sent to my personal email address, it has the title “Here’s this month’s Spark bill”</p><p>I have created a Gmail Search Filter that applies a forwarding rule to any new mail titled “Here’s this month’s Spark bill” and will forward it to my expenses@mydomain.com, this is then processed by the PDF converter and my associated outlook rules, then processed by Zapier, and ultimately ends up in Hnry.</p><p>This takes what would of been a 6 step manual process of checking my emails, logging into my spark account, downloading the PDF, logging into Hnry, uploading the PDF, and submitting the expense. Into a simple task of just submitting the expense.</p><h3>Conclusion</h3><p>If your like me, accounting is not my first choice of things to do,I often procrastinate when it comes to filing expenses. So implementing some automation makes this a easy task so I can spend more time enjoying what I do.</p><p>If you need any advice setting up rules in Zapier/Outlook/Gmail feel free to reach out to me at <a href="/service/mailto:alexander@krispy.co.nz">alexander@krispy.co.nz</a> or contact Hnry Support.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a57cd9c314d5" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>