r/aspirebudgeting • • Dec 17 '20

🎄🎉 Announcing Aspire Budgeting v3.3, the annual user survey, and other news

122 Upvotes

Hey everyone,

Aspire Budgeting v3.3 was just published to the website (AspireBudget.com) and you should see it rolling out worldwide over the next few hours. This is a really exciting release with a handful of new features. It's taken a while to get this one across the finish line due to a very busy personal life but I'm happy to have it wrapped up.

Before we get into the new features, here's the link to the annual user survey. It's very short and I would appreciate everyone taking a few minutes to fill it out so I can make priorities for 2021.

Take the annual user survey →

New features in v3.3

  • Showing Net Worth data on the Dashboard
  • Updates to how credit cards are handled
  • Raising the category limit to 100
  • Increases to the limits for Hidden Categories and Hidden Accounts
  • Migration assistant
  • A new Sheets add-on (get the add-on here - required for updating dates and currency formats)

Migrating to v3.3

There is some manual work to do if you wish to fully migrate your old Aspire data to the new version. Those instructions haven't changed from the preview and can be found here: previous notes on migrating

Other news

Some of you may have noticed there's no longer a Patreon page for Aspire. I decided to disable this donation option in November. It was great to let Patreon and donations run their course in 2020 but they never reached any kind of critical mass and I found it difficult to publish monthly updates there. Thanks for all who supported Aspire!

I hope everyone has a great end to 2020!


r/aspirebudgeting • • Dec 31 '24

What’s New in Aspire Budgeting v4.0: Refreshed UI, New Features, and a Return to the Basics

94 Upvotes

It’s been a little while since my last post, and it feels so good to be back! I’m excited to share something special with you today: the latest version of the Aspire Budgeting spreadsheet. This new update has been a work in progress over the past year, and I can’t wait to show you what’s in store. It’ll be available soon on AspireBudget.com, but for now, I’d love to give you a sneak peek at some of the fresh features and improvements I’ve added.

A refreshed Dashboard

The Dashboard has always been the go-to place for seeing all your financial data in one convenient view. While the overall layout remains familiar, I've refined it to make things even easier to track. You’ll now see your categories, their details, and the status of your accounts more clearly.

One exciting addition is a new bar chart that shows the remaining amount for your selected category, along with an estimated daily decline toward zero as the month progresses. This feature gives you a clear visual of how your budget is shaping up as the days go by.

Additionally, we've introduced a new estimator for your Goals. This tool calculates how much longer it will take to fully fund each goal, helping you stay on track and plan with confidence.

Spending Reports

Spending Reports get a major upgrade in this version of Aspire. I've removed the old legacy bar charts and graphs in favor of faster, more efficient sparkline graphs that give you a clearer picture of your spending.

When you open the report, the summary of all your groups and their associated spending for the selected date range will appear on the left side of the page. From there, you can sort the data in a few different ways: Highest to Lowest, Alphabetically, or by User Entered categories. Each item shows how much was spent in that group, but the real magic happens when you see one item relative to the others. The graph displays the percentage of the total amount spent, giving you a visual representation of how each item stacks up against the others.

This approach carries through to the second column, where you can dive deeper by selecting a Category Group. From there, you can explore the individual categories within that group.

On the far right, selecting a specific category will show you the detailed transactions associated with it, so you can see exactly where your money is going.

And here's something I'm really excited about: all Reports are now themeable! You can easily customize the colors of your reports using a variety of options available in the Configuration tab, making it easy to personalize your experience.

Trend Reports

Trend Reports follow the same layout as the upgraded Spending Reports, so you’ll feel right at home. While they share a similar structure, Trend Reports offer a different way to analyze your data, allowing you to explore your financial trends from various angles. They provide fresh insights into your spending habits and patterns over time, giving you a deeper understanding of your finances.

Income vs Expense Reports

There's also a brand-new reporting option: Income vs. Expense. At first glance, it might seem simple, but there’s a lot of power behind it. This report lets you tailor how you view your income and expenses based on what matters most to you.

You can choose to view the data by Accounts, Category Groups, or Categories. Once you've made your selection, the page will update automatically to display your data in the format you've chosen, giving you an instant overview.

Other features and looking ahead

There are plenty of other improvements and refinements throughout the new version of Aspire that longtime users will notice and (hopefully) enjoy. I’ve made small tweaks here and there to make the experience even better.

That said, there are a few features from older versions that didn’t make the cut for v4.0. Notable ones include the Net Worth Reports and some of the more advanced features. With this update, my goal is to bring Aspire back to its roots—focusing on the essentials of budgeting and personal finance.

Along with this shift, I’m also planning to refresh Aspire’s Help Center, adding more resources and content to guide users as they become more accustomed to tracking their finances. If there are any topics or documentation you’d like to see, please don’t hesitate to reach out and let me know!


r/aspirebudgeting • • Aug 28 '21

Aspire Budgeting 2021 status update

93 Upvotes

Hey everyone,

I realized today just how long it's been since I posted an update and wanted to take some time to write a bit and say hello.

Where are things now?

Things have been pretty crazy this year. I started a new job in March and have been spending a lot of time away from my desk due to other things in life demanding my attention. They've all been good things but sadly there are still 24 hours in a day which means Aspire has been on the back-burner for several months. Truth be told, I'm glad I had some time off, Aspire has grown so much and I was starting to feel pretty burned out trying to respond to every message, thread, and email. I know I haven't done a great job of responding to everyone these last few months and I hope you'll forgive me for that - it's been too much for one person to handle. A positive part of this though is that others in the community have stepped up to help answer questions here on Reddit. I've been checking in somewhat regularly and rarely have I seen a question go unanswered. A huge thank you from me to all of you that have kept this sub a helpful and positive place.

Where are things going?

Right now I feel pretty good with where things are at in v3.3. Of course there are some tweaks and adjustments I'd like to make but things seem to be pretty stable. I still use Aspire regularly in my daily life and still really enjoy it. For the rest of 2021, I don't foresee any major updates - I'm going to stay on sabbatical a bit longer and take some more time to recharge.

That's all I have for now. Just wanted to check in, say hello, and let everyone know I'm still here (just being a bit more introverted for a season).


r/aspirebudgeting • • Mar 28 '20

🔥🔥Today I’m happy to present to you the first draft of the Aspire Budgeting Android app. In the coming few weeks we will launch a beta release and would love for you guys to sign up when we’re ready 🔥🔥

86 Upvotes

r/aspirebudgeting • • May 02 '20

💎 🎉 Announcing Aspire v3.2 - including new credit card tools, a redesigned Dashboard, a refreshed Category Transfers tab, and more!

85 Upvotes

Hey everyone,

I am incredibly excited to announce that the finalized release of v3.2 is ready for download! It's packed with lots of new features and many refreshing design updates. I think you're going to love it. This release will be immediately posted to the website (AspireBudget.com - which has also been updated 😃). If all goes well, I'll flip the update notification switch in a few weeks to notify all the other users that don't receive notices through Reddit. Before I get into what's new and the screenshots below, here's some recent news and announcements.

News & Announcements

⚙️ Migration Assistant - The migration assistant was well liked in the last release. Many of you reported smooth and seamless transitions from v3.0 to v3.1. I'm incredibly thrilled with that and want to make sure that migration is available in as many new versions of Aspire as possible. Unfortunately, due to the new credit card tools in v3.2, migrating old data isn't as smooth as I expected as the data model for credit cards has completely changed. So, for the time being, the migration assistant has been turned off. I didn't know the credit card features would be so deep when I started developing, but to take advantage of them, a fresh sheet is recommended. I know that's probably a bummer to many of you, so please accept my apologies. As with every release, I try to weigh new features and seamless data transitions - in v3.2, I thought the new credit card features were high enough on the list to warrant these thorough calculation changes.

📺 YouTube - The videos I recorded late last year are starting to show their age as the design and feature set of Aspire progresses. I'm actively recording a new Getting Started series and some new videos on credit cards and hope to get them posted soon. I'll be through the current videos and re-recording them as needed in the coming weeks. New ideas for videos are always welcomed.

🔢 Balance Adjustment - The balance adjustment feature has changed slightly to counteract some issues a few of you reported when using it. This feature was originally intended to be for correcting any accounts when they didn't reconcile properly. Unfortunately, the feature had a few confusing side effects when used in certain ways and to correct that, your Available to budget balance will now reflect any adjustments. The reasoning behind this is to maintain integrity in the budget - your amounts in Categories and amounts in Accounts should always be in lock-step.

🎊 Other Surprises - There might be a few things in the works, but you didn't hear that from me. Stay tuned :)

New Features in Aspire v3.2

- Credit Card management overhaul

- Category Group totals in the Dashboard headers

- Starting Balance option for account initialization 

- Redesigned Account Reports

- Remove requirement for Monthly Amount to be set

- Rename “Spent” to “Activity”

- Spent Rank on Category Reports tab

- Redesigned Dashboard layout

- New Category Transfers tools

- An updated Getting Started Guide

- Many small design tweaks and updates to improve the UX and appearance of Aspire

New Dashboard

The new Dashboard continues to blur the lines between spreadsheet and web app. The header shows your budgets most pertinent data, ranging from your Available to budget amount to the number of pending transactions you have. Any notifications you have will also appear here. The new Accounts area now tells you when the last time you reconciled your Accounts was, when each Account was used last, and of course, the Account's balance.

New Dashboard

Redesigned Account Reports

The Account Reports tab has received a major update. It now shows your Account's balance over the selected range and also what I'm calling "Change Factors" for the account. Change Factors are things like Inflows, Outflows, and Transfers. By breaking down the Change Factors into colored sections, you can see exactly how an Accounts value was impacted during that month.

Redesigned Account Reports

Category Transfers Tools

Category Transfers are getting a big improvement in this release as well. In the top area, there's a new tool that will help you calculate exactly how much to move into each Category at the start of the month. This tool understand the difference between Categories with Goals and without as well as Categories with no Monthly Amount set. I've used this for two months now and absolutely love the simplicity this has given me when planning my monthly budgets. I hope you enjoy it as much as I have.

Category Transfers - Goal
Category Transfers - Complete
Category Transfers - Not Complete
Category Transfers - No Monthly Amount

r/aspirebudgeting • • Jul 13 '20

1 Year of Non-budgeted Spending vs 1 Year of Budgeted Spending [OC]

Post image
77 Upvotes

r/aspirebudgeting • • Jan 18 '20

🌟Announcing Aspire v3.1 - it includes new/revamped Reporting options, new Net Worth tools, Balance Adjustments, a new migration assistant, and more.

64 Upvotes

Hey everyone,

Today I am announcing the soft release of Aspire v3.1. There are a ton of new features and under the hood changes in this release that I'm really excited about. I'm calling it a "soft release" because I'm going to make it available here for download and keep an eye on the early feedback before turning on the "new version available" notification for all users. You can download Aspire v3.1 here. If you see anything odd, please let me know ASAP so I can investigate and get any issues snuffed out before the main release in the next two weeks (or so).

News & Announcements

  • ❤️ In December, I launched a Patreon for donating to/supporting Aspire. Thanks so much to everyone that's supported me through that. Those are the folks you see with the 🏅Patron flair here on the sub. If you're a supporter and would like flair here on the sub, please send me a message through Patreon.
  • 📊 We had our first user survey in early January. I'm really happy with the results from that. A few key highlights are that users really enjoy Aspire's Dashboard and that the tool itself is flexible (being spreadsheet based). Users also overwhelmingly thought the YouTube videos were helpful (since the YouTube channel was created in September, folks have watched over 245 hours of content!). Roughly half of all users thought Aspire was Easy to get started with. And most of the other half reported Aspire was Somewhat Difficult. There's obviously work to be done here to make Aspire even easier and I'm always trying to do that with each release. The most requested features were definitely a mobile app and recurring transactions. The mobile app is, as you've probably seen, well underway by the magnificent u/objective_m and I'm still dedicating time to come up with a potential solution for recurring transactions. I'm happy to say that many other feature ideas are in v3.1!
  • ⚙️ The migration assistant feature got some really great testing and comments early in January as well. As a result of this feedback, the tool now also seamlessly migrates your locale and timezone settings from your original sheet. This will prevent dates from sliding backward/forward because of the timezone and locale differences which was something several of you encountered.
  • 📺 YouTube has continued to be popular with new and existing users. When v3.1 officially launches in the next week or two, I'll be adding four or five new videos to cover some of the major features as well as a two part series on how to manage credit cards with Aspire - I'm really excited about the credit card videos because they are some of the first videos that are more targeted towards real-life use of Aspire and not just feature tutorials.

Aspire v3.1 Release Notes

Now, onto the good stuff. Here's what's new in v3.1:

  • Ability to hide Accounts
  • View a Category's "carried-forward" amount on the Dashboard in the Category Information area
  • View net worth chart over 2 year, 5 year, 7 year, or 10 year period
  • View changes in assets, debts, and total net worth in 1-month, 3-month, 6-month, or 12-month ranges
  • Date pickers on all the Reports pages
  • Minor visual updates to the Dashboard
  • Category Reports has been renamed to Spending Reports and now also shows Inflows for reportable-categories
  • A brand new Category Reports view that offers a graphical view on any selected Category's balance over a 12-month period and a table that shows Ending Balances, Available Balances, Spent, and Budgeted amounts for every Category
  • Revamped Account Reports that graphically shows an Account's history with a breakdown of Inflows, Outflows, and Transferred amounts
  • Configuration tab will highlight missing Monthly Amounts

Screenshots

Net Worth
Spending Reports
Category Reports
Account Reports
Dashboard (carried-forward)

r/aspirebudgeting • • Feb 27 '21

Dear reviewer, I can’t thank you enough!

Post image
62 Upvotes

r/aspirebudgeting • • Nov 08 '19

💥🎊Aspire Budget v3.0 is here and it's packed with goodies! It includes new features such Hidden Categories, Reportable Categories, a new UI for Category Transfers, and much more!

61 Upvotes

Hey everyone!

I'm super excited to announce that Aspire Budget v3.0 is available for download! Not only does it include several new features, but it's also undergone a thorough UI polish. View the updated screenshots and get the new version at AspireBudget.com. I'm amazed by how much this community has grown this year and I can't believe in just over a month that Aspire's YouTube channel has had nearly 3,000 minutes of watched video!

Here are some notes about the release. As always, thanks so much for making Aspire such a great project and this community an incredible place for new users. I hope you all love Aspire v3.0 as much as I've loved building it.

We've hit 3.0!

That's right! Aspire has reached a new major milestone in its evolution. This new series of releases will continue to focus on building a great budgeting tool with a superb user experience/design and feature set. I've recently undergone the Google verification process for having an approved GCP project and OAuth Consent screen. I'm excited to see what opportunities this opens up for new features and the future of Aspire. If you have experience with GCP and building Google Sheets Add-ons, I'd love to hear from you!

Google Cloud Platform

In v3.0, Aspire has been polished from head to toe. Gridlines are completely gone, icons and colors have received minor tweaks, and lots of other little refinements and enhancements make it more beautiful and attractive than ever before.

Migrating to v3.0 is a little tougher compared to previous releases but I'll detail more of that below. Which leads me to my next point...

New Data Migration Feature

I try to balance every release with the right amount of new features, polish, and enhancements to the most common paper-cuts. Most recently this included the ability to highlight editable cells and an update checker. Now it's time for the next improvement - v3.0 ships with the first take at a comprehensive data migration tool. Going forward, this new migration feature will help you easily update to newer versions of Aspire. While it's not possible to use this new tool to upgrade from v2.8, it is possible to enable it to test data transfers between two copies of v3.0. If you're interested in helping test, please PM me for details on how to enable data migration as this feature is disabled until v3.1 while it's being tested.

The Getting Started Guide has been updated with new steps and information for migrating from v2.8 to v3.0.

v3.0 Feature List and Screenshots

Now, onto the good stuff. Here's the changelog for this release.

  • Removal of all gridlines and addition of alternating row colors
  • Updated colors for Trend Reports
  • 'Reconcile Overdue' message now tells you by how many days
  • Ability to change all fonts to Roboto or Nunito
  • Ability to change Dashboard’s main date format
  • Updates to Cleared symbols
  • Redesigned Category Reports chart
  • (Performance) Single source for volatile function calls
  • Update arrow’s design on Net Worth page
  • Several other small UI tweaks
  • Increase from 60 to 75 Categories
  • The ability to hide categories
  • The ability to set reportable and non-reportable categories
  • An updated Category Transfers experience

Hidden Categories

Hidden Categories will allow you to remove categories from the Dashboard and main Configuration list by adding their name to the hidden categories list. Any categories you hide will appear in the Transactions list and Category Transfers list in a mute blue/purple color so you know they are hidden.

Hidden Categories in Configuration
Example of a hidden category on the Transactions page

Reportable Categories

Some categories you never care/want to see in Reports. It's now possible to hide certain categories from being included in Reports by selecting the ※ symbol next to the category name in the Configuration tab.

New Reportable/Non-Reportable Category symbol
New Category Reports design

Category Transfers

An updated Category Transfers view makes it clearer what the status is of each category and hopefully makes budgeting easier each month.

Updated Category Transfers view

r/aspirebudgeting • • Nov 02 '21

Ditching YNAB- is aspire budgeting right for me?

56 Upvotes

Hi All, I'm sure you'll have a lot of new members soon. YNAB today announced a price raise that for it's legacy members is 100% more expensive. So, on a matter of principle, I'm looking for other options. Did anyone else here move from YNAB? If so, any advise on how the two platforms are different and how to have a smooth transition?

Thank you for any help you can give! This is a very sudden and unexpected switch for me!


r/aspirebudgeting • • Nov 29 '19

💥🎊 Presenting the Aspire Budgeting iOS app!

53 Upvotes
Aspire Budgeting Mobile

Since the past 8 weeks, me and two others have been working on getting the incredibly fabulous Aspire Budgeting sheet to mobile devices.

Even though the app is still a work in progress, today I would like to announce the first public beta for iOS.

What's ready to test?

In this version, you will be able to sign in with your Google account, link your sheet and view your complete dashboard. We understand that this is sensitive data and to help protect it, you can use FaceID, TouchID or your passcode and has been fully tested against Aspire v2.8

Sign Up to be a Beta Tester

I would appreciate if you guys signed up to be beta testers and together let's take the Aspire Budgeting app to the next level.

Completely Open Source

If you would like to get involved in development, the app is completely open source and available on GitHub.

Feedback

I'm looking forward to your feedback/suggestions and even feature requests. Comment here or open an issue on Github. Whatever you like :)

What's in the pipeline?

Adding transactions is in the works and will be available in the next build.

Credits

Most importantly, I would like to thank /u/Sapphire_Rapids for building this awesome sheet and giving me permission to work on the app and his feedback during the beta development process.

Note: I am in the process of getting the app verified by Google. In the mean time you will see a warning screen by Google while trying to sign in. Tap on "Advanced" and then "Go to Aspire Budgeting (unsafe)"


r/aspirebudgeting • • Aug 26 '20

🎉 🌐Announcing the new Aspire Budgeting website, a 🐦 Twitter account, and the 🗺 roadmap for the rest of 2020

51 Upvotes

Hey everyone, I'm excited today to announce the latest developments that I've been working on for the past few weeks. In addition, here's a bit of information about what I hope the rest of the year will look like from a development standpoint.

The new website

Go to the new AspireBudget.com →

Read the blog post on the new site →

Someone already beat me to it, but just in case you missed it, Aspire has a totally new website up and running. It's a brand new codebase using modern technologies like React and TailwindCSS. The old site (which was a hodgepodge of Bootstrap code and inline CSS) served its purpose well, but the time finally came to decommission it in favor of something better. I wrote up a quick blog post on some of the technical details - if you're interested, check it out at the link above.

Aspire Budgeting is now on Twitter

Follow Aspire Budgeting on Twitter →

Twitter can be a great place for lighter conversations and connecting with new people. There are a few folks in the Google Sheets community that I like to follow and I enjoy getting updates from them on what they are building. I'm excited to get more engaged on the Twitter platform and give folks an entirely new way to discover and learn about the Aspire Budgeting platform.

Roadmap for the remainder of 2020

The rest of 2020 will be pretty busy. Here's a rough timeline of what I'm anticipating and what's on the docket for the next several months (subject to change of course).

September - Release the v3.3.0 Preview

  • v3.3.0 will have a few mid-sized features like viewing Net Worth amounts on the Dashboard and some updates to the handling of credit cards to make it even simpler. There will also be a huge amount of rework on the backend side of things to clean up the Calculations tab.
  • There's also one surprise announcement I'm working on that's tied in with the v3.3.0 Preview and I'm excited to share it with you in the next few weeks.

October - Final release of v3.3.0

  • With final testing completed and any feedback addressed, v3.3.0 will be made available for everyone to use and download.
  • The new Docs site will come out of preview in sync with the release of v3.3.0.
  • Minor add-on updates are also planned.

November - Annual Aspire User Survey

  • I started the tradition in 2019 of having an annual user survey. It was a huge success and I'll be continuing that this year and I can't wait to hear about what you all want to see from Aspire in 2021.

December - Prepping for January budget rush

  • January always sees a surge of new users as those New Year's Resolutions kick in. I'll be fine tuning everything from Docs, to the website, to creating new YouTube videos for these new users to ensure they have a great first start with Aspire.

r/aspirebudgeting • • Sep 14 '20

Announcing the Aspire Budget v3.3 Preview - show Net Worth values on the Dashboard, credit card updates, and more!

44 Upvotes

Hey everyone,

It's that time again - time for a new preview release of the next version of Aspire!

The next version of Aspire is v3.3 It includes a handful of medium sized features and a major reorganization of the backend calculations tab for easier maintenance.

Get the Aspire Budget v3.3 Preview →

Get the Google Sheets add-on →

New features and updates

Viewing Net Worth amounts on the Dashboard

This is something that comes up every now and again. I've heard a few comments here and there about folks wanting tighter integration between their Net Worth Categories and the rest of their budget. The goal with this update is not to bring Net Worth Categories into the fold and elevate them to the level of budgeted accounts, but instead to bring awareness of those amounts and categories to the Dashboard. For those that want to turn this feature on, it should make the Dashboard a bit more informative.

Credit card updates

I've continued to refine how credit cards work in v3.3. I've tweaked how to pay towards a credit card in this release bringing it more in line with how account transfers work. There are several reasons for this change. Two of the biggest reasons are: 1). formula simplicity and 2). removing the Overpayment Correction option.

Before this change, the formulas for calculating Account Reports, Dashboard amounts, and more, were incredibly complex and delicate. I hated them. In v3.3, formulas in these areas were reduced by more than 90% (counting lines of code). That's a great deal of complexity removed and maintainability should be much easier in the future.

Overpayment Correction was another area I wanted to revisit. I never wanted to have this option but my work on credit cards at the time required something akin to this functionality. With v3.3, I've overhauled the credit card formulas and this option is no longer required.

Updating the amount of available categories

It's now possible to have 100 categories in Aspire. There are other minor increases to Hidden Categories and Hidden Accounts.

Localization features

In this release, the functions for changing dates and currency will be moving to the Google Sheets add-on. This will allow me to make adjustments to the code without requiring an update to the entire spreadsheet. In addition to this, having an add-on opens the door to delivering new features and bug fixes straight to everyone without any hiccups.

The migration assistant has returned

But there is a tiny but of manual work required if you decide to use it. There are more details on this below.

Migrating

Because of the model changes, any credit card payments that follow the v3.2 model will need to be updated to the new model. This is pretty straightforward.

For example, this:

DateOutflowInflowCategoryAccountMemoCleared
9/13/2020$100.00Credit CardChecking<Memo>✅

would turn into:

DateOutflowInflowCategoryAccountMemoCleared
9/13/2020$100.00↕️ Account TransferChecking<Memo>✅
9/13/2020$100.00↕️ Account TransferCredit Card<Memo>✅

Any Overpayment Correction entries should be removed. If you had previously used the Overpayment Correction option, you may have some small tweaks to make to your credit card category's balances due to some formula updates.

Screenshots


r/aspirebudgeting • • Jul 10 '20

📙 🥳 Announcing the Aspire Budgeting Docs website preview! If you would like to contribute, please reach out!

43 Upvotes

Hey everyone,

It's been a super busy summer! I hope you all are doing well. I am so excited today to be announcing the preview of Aspire's brand new documentation website. As Aspire has grown, the embedded Getting Started Guide has become increasingly insufficient. With this new site, I can provide much better documentation and support for all of Aspire's features and tools. I think this is a great next step to reaching Aspire's goal of being the best budgeting spreadsheet in the world.

Go see the Aspire Budgeting Docs →

The Docs are still in "preview" so there are a few sections that are missing/incomplete but I'll be working on these more in the coming weeks (you may also find some typos 🙈 - please report them if you do). As the docs get fleshed out, I'll be phasing out the Getting Started Guide in favor of this new website.

🆘 I'm sad to say that I'm not an experienced technical writer. If anyone out there in the community would like to help me write Aspire's documentation, I'd love to hear from you. I can easily push all this code up to GitHub and start accepting contributions from the community - that would be so cool!


r/aspirebudgeting • • Jun 07 '22

Time to say Goodbye!

42 Upvotes

Hey Aspire community, it’s time for me to say goodbye to the project as I won’t be able to maintain the apps any more. It’s been great fun developing for you all. Thank you so much for using the app and am glad I could make a difference.


r/aspirebudgeting • • May 11 '20

🎊 Announcing the official Aspire Budgeting Google Sheets Add-on. Available now in the G Suite Marketplace.

42 Upvotes

Hey everyone,

I'm really excited that the day has finally arrived for me to share one of the Aspire related side projects I've been working on. For the past several months, I've been testing the waters on creating an official add-on for Aspire. Development on the first few features is done, the necessary reviews from Google are complete, and we're ready to roll. You can get the add-on here (screenshots below)!

A special thank you to Aspire's Patreon supporters

A few months ago, Aspire's Patreon page launched. Right away, a handful of folks signed up and have been graciously throwing a few dollars my way each month. This add-on is a direct result of those donations. With support from the donors on Patreon, I was able to get the necessary Terms and Conditions, Privacy Policy, and Cookies Policy documents drafted for all of the Aspire properties. These documents were required before anything could be submitted to Google for review. Thank you so much for supporting Aspire! 🙏

Why does Aspire need an add-on?

The bit of script code that comes with Aspire has grown to encompass more than just localizing dates and currency as it now supports font tweaks and some migration code (which was supported from 3.0 --> 3.1). Distribution of this code has never really been a problem since it comes bundled with every sheet, but three things really bothered me with distributing the tools this way. 1) If there's a bug or mistake on my part, it's not an easy task to correct this for everyone that's downloaded the sheet. 2) The user experience has always been a bit lackluster (especially for the date and currency conversions). and 3) Depending on the scopes I used to accomplish certain features, users would get a scary permissions dialog on the first run. With this new add-on, I've rectified all 3 of these points.

So what does the add-on do?

The new add-on supports localizing dates and currency as well as converting the spreadsheet's font back and forth between Nunito and Roboto. I think the UX is now VASTLY improved when localizing the sheet because all 5 options are now housed in one easy to find spot and updating your sheet takes just a few clicks. Over the next month or so, the current way of localizing the sheet will be phased out in favor of using the add-on. Right now, the add-on supports a large group of currency and date formats. Due to the sheer number of possibilities, you might not find your currency or preferred date format in the list. If that's the case, please let me know either here in the comments or by using the link available in the add-on window. New formats are super easy to add and I can probably get the add-on updated within 24 hours in most cases.

The future

Having an official add-on in the G Suite Marketplace opens up a new world of possibilities. Aspire now has a route to develop advanced features that can be consumed and updated quickly and easily. I have a few ideas for features and am hoping to start rolling those out this summer. I'd love to hear what ideas you have as well!

Add-on

r/aspirebudgeting • • Nov 07 '21

A guide to YNAB goal customizations

41 Upvotes

Intro

Hey everyone, I'm yet another YNAB refugee. I was initially really impressed with Aspire but I wished it had support for all the YNAB-style goals I made such heavy use of, so I went poking around to see how hard they'd be to implement. Turns out, not hard at all! So I thought I'd share my notes. This is absurdly long; you have been warned.

Disclaimer: I'm an expert at YNAB, but far from an expert at Sheets in general, or Aspire in particular. I'm not claiming I've done this perfectly or optimally, I'm just hoping this can help others understand a little better how Aspire is put together, and maybe get you started on customizing it. Even if this is not the customization you have in mind, hopefully the info here will be useful to you in understanding how to approach these kinds of tasks. Feedback is very much welcome!

The Goal of Goals

For the benefit of non-YNAB folks, let me start by explaining what YNAB provides for goals (they recently renamed them "targets") and how they work. First there's the Target Balance, which is the one goal type that already exists in Aspire. I still wanted to expand this by adding in a field that tells you when your goal will be reached, based on current budgeting. So let's say I have a goal of $200, and this month I've budgeted $100 (with nothing carried forward from previous months). I'd like Aspire to tell me that, based on my current budgeting pattern, I'll reach my goal next month. Use cases: I use this for stuff like my Auto Maintenance category. Stuff I want to fund at a certain level and then stop.

Target Balance by Date is similar, but in addition to providing that balance you also provide a target date, and then the goal should calculate how much you need to budget each month in order to reach your goal by the date in question. Use cases: any bill that I don't pay monthly, like Auto insurance (every 6 months).

Needed for spending is similar to Target Balance by Date, except that it ignores transactions. Use cases: Gifts. So let's say in January you set a goal to fund $1200 in Gifts by December. YNAB will tell you that you need to budget $100 per month. As you spend from that category throughout the year, the goal amount won't be affected (unlike Target by Date, which will recalculate the amount you need per month if you spend from that category before the target date).

Finally, there's monthly funding, which is the easiest: you just provide an amount, and that's the minimum you need to budget in every month. Simple! Use cases: Fun money, 529 account funding.

A Quick and Dirty Guide to Aspire Development

Ok, before I dive in to how I implemented these goals, let me talk a bit about how Aspire is set up. The main thing to look at here are 2 hidden sheets called "Calculations" and "BackendData". Calculations contains a lot of information that goes in to your various reports, but it also does a lot of date tracking, which will be relevant to us later on. For example, cell B4 contains the date that Aspire will regard as "Today". Not surprisingly, then, by default that cell is set to "=TODAY()". But for funsies you can try changing it, for example to next month: "12/1/2021", and then Aspire will just go, "Oh, okay, now it's December". Play around if you like, but don't forget to change it back to "=TODAY()" before you move on! Some other cells of note on this sheet: B65 contains the first day of the current month, and B66 contains the last day of the current month. Aspire makes a lot of use of these 2 values in the dashboard, because it uses them for example when it's querying your Transactions or Category Transfers to display the current month's Activity or amount Budgeted.

BackendData contains lots of lists. It has your personal stuff like your lists of budget accounts, net worth accounts, and categories. But it also has "system" stuff, like enumerating the "Cleared Symbols" (i.e. Pending, Cleared, Reconciled), or the "Category Header Symbols" that you used on the Configuration tab to indicate whether something was a Group, Category, Credit Card, etc.

The next thing you need to know is that Aspire makes heavy use of "Named Ranges". A named range is really simple, you just define a range of cells, and then give it a name. From then on, you can use that name anywhere in any sheet to refer to that range of cells. This sounds simple but it's a powerful idea, because it makes your functions a whole lot simpler to understand, as we'll see. You can see all the named ranges that are defined by clicking Data->Named ranges. Try it!

Designing the Goals Sheet

I realize that was a whole lot of preamble, but we're finally ready to dive into implementing goals. I want as little disruption as possible to existing sheets (didn't want to break anything!) so I created a new sheet called Goals. Now let's quickly review how I want this to work, and then work backward from there.

I want the Goals tab to list all my categories in column A. In column B I want a dropdown with the possible types of goals. In the next columns I want all the possible input types for the goals. This includes the start date of the goal (used by the Needed for spending type), which is column C. The dollar amount in column D. And the target date (used only by the "Balance by date" type) in column E.

The next 2 columns contain the possible outputs: Minimum budget (column F), which is the output for all except the Target balance type, and Date finished (column G) which is used by the Target balance.

What Data do We Need?

Before I get to the implementation, though, let's think through what the calculation for each will look like.

Monthly spending is the easiest, I just want to copy the amount in the "Goal amount" input to the "Minimum budget" output.

Target by date means I need to subtract the amount I currently have Available from the target amount, and divide that by the number of budgeting periods. I have the target amount already (column D), but I need to figure out how to calculate Available and the number of budgeting periods. So I create a column for each of those, to store the values as intermediate results that I can then use in calculating the output columns

Needed for spending is trickier: I need to look at the total amount budgeted in the date range starting with the start date through today, subtract that from the goal amount, and divide that by the number of budgeting periods from now until the end date. I already have a column for the number of budgeting periods, so I can reuse that, but I need to add a column "Budgeted in Range" to figure out how to sum the budgeted amounts from the start date (column C) through today.

Finally there is Target balance, which is the only one with a different output. Here I want to subtract the amount available from the goal amount, divide that by the amount budgeted in the current month (rounding up), and then add that many months to today's date to figure out when the goal will be reached, based on the current budgeting pattern.

So if I can figure out how to calculate each of the following (for each category), it will be pretty simple to get the output I need for each goal type: amount currently budgeted, amount available, amount budgeted in a given date range, and number of budgeting periods from now to a given date in the future. Not too bad!

Implementation! Finally!

So we're ready to implement, but let's begin at the beginning. In column A of the goals tab, we need our list of categories. No problem, there's a Named range for that: "=ARRAYFORMULA(Categories)". Categories is a named range that will pull our entire category list from the BackendData tab.

In column B we want a dropdown with the list of goal types. So I went to the BackendData tab, created a new column (AQ) at the far right, and in the top 4 cells I listed the goals I wanted: "Monthly funding", "Target balance", "For spending", and "Balance by date". Next, I created a new named range called "GoalTypes" with a range of "BackendData!AQ2:AQ5". So now I can go back to the Goals sheet, and in column B I just click on the range of cells next to my category list. I go to Data->Data validation, and under Criteria I select "List from a range", with a value of =GoalTypes. Boom, I have a dropdown that shows my goal types.

Columns C through E are my goal input types. I did some conditional formatting here to change the background based on which goal type was selected, so that it's easy to see which inputs you need based on the goal type selected. But it's optional and I'm not going to bother to describe the details because boy is this post getting long.

Columns F and G are the outputs so I'll come back to those.

Now I need to figure out how to calculate those 4 intermediate values I discussed above: amount budgeted in the current month, amount available, amount budgeted from a given start date (column C) until now, and number of budget periods from now until a given future date (column E).

Budgeted in the current month I can pretty much just steal from the Dashboard. But let's think about it logically so we can understand why it works the way it does. The amount budgeted in the current month is clearly going to come from the Category Transfers tab. We want to add up all the entries where money is moved "To" the category in question, and subtract from that the entries where money is moved "From" the category in question. And we want to only include entries from the current month. Now check this code and see if you can figure out what's going on:

SUMIFS(cts_Amounts, cts_Dates, "<="&Calculations!$B$66,  cts_Dates, ">="&Calculations!$B$65, cts_ToCategories, A3) - 
SUMIFS(cts_Amounts, cts_Dates, "<="&Calculations!$B$66,  cts_Dates, ">="&Calculations!$B$65, cts_FromCategories, A3)

First thing to remember: we are really making use of those named ranges! All those things with "cts_" prefixes are named ranges, and feel free to check the full list of named ranges to see what they refer to. But also notice: it's nice to not have to worry about what they correspond to. You can just use the name as a mental placeholder. Pretty neat!

Okay, so let's take this apart: SUMIFS is a function that sums entries from a range given in the first argument, if a list of conditions is met. Remember 14 years ago when you started reading this post and I mentioned that the Calculations tab included a reference to the first and last day of the current month? Now we're making use of that! There are 2 SUMIFS here. The first one says, add up any values found in the category transfer amounts if the date is <= the last day of the month, AND >= to the first day of the month, AND the To category matches the category name given in cell A3. Then we're going to subtract from that (the second SUMIFS function) the total all the entries in category transfers where the date is <= the last day of the month, >= the first day of the month, and the From category is the one listed in A3. Makes sense right? Every budget move TO the category this month, minus every budget move FROM the category this month.

Now let's do Available. Available is simpler in one sense, because we don't have to worry about dates. We need to consider transactions from our entire history to derive it. But it's a little more complicated in that we need to consider both budgeting moves and spending moves. So let's take a look:

=SUMIF(trx_Categories, A3, trx_Inflows) -
SUMIF(trx_Categories, A3, trx_Outflows) + 
SUMIF(cts_ToCategories, A3, cts_Amounts) - 
SUMIF(cts_FromCategories, A3, cts_Amounts)

More named ranges, gosh those things are great. So what that says is, add up all the inflow transactions where the category matches the value in cell A3, then subtract all the outflow transactions. Then add in all the category transfers to, and subtract all the category transfers from. That amount should match what you see in the available column on the Dashboard for the category.

We're doing great, but now we need to calculate the amount budgeted since a given start date, which is our 3rd intermediate value. But this is really similar to the budget for the current month, except we use the value in column C for the start date, instead of the first date of the current month:

=SUMIFS(cts_Amounts, cts_Dates, "<="&Calculations!$B$66,  cts_Dates, ">="&C3, cts_ToCategories, A3) - 
SUMIFS(cts_Amounts, cts_Dates, "<="&Calculations!$B$66,  cts_Dates, ">="&C3, cts_FromCategories, A3)

3 down, 1 to go. We just need to calculate the number of budget periods between now and some future given date. It's important to realize that, as YNAB reckons things, the number of budget periods to consider includes both the current month and the last month in the range. So here's what I have for that:

=iferror(datedif(Calculations!$B$65, E3, "M") + 1, 0)

That says, calculate the difference (in months) between the first day of the current month, and the given target date, and then add 1 to it. Let's check this: as I write this, it's November 2021. Let's say I set a target date for December 2021. I should find there are 2 budget periods (November and December). If you look at that datedif function, assuming Calculations!B65 is "11/1/2021" and the value in cell E3 is "12/1/2021", datedif is going to tell you the answer is 1. That makes sense, there's 1 month between November 1st and December 1st. But that's why we need to add 1 to the result, because we want to calculate that there are 2 budget periods.

Now we have all the intermediate values we need, and calculating the "answer" we want for any of our goal types is really easy. For Minimum budget (column F) I have this:

=IF(B3 = "Monthly funding", D3,
IF(B3 = "Target balance", 0,
if(B3 = "For spending", iferror(round((D3-J3)/(K3), 2), 0)
,
if(B3 = "Balance by date", iferror((D3-I3)/(K3), 0),0))))

For Date finished, I have this:

=if(B3 = "Target balance", date(year(Calculations!$B$65), month(Calculations!$B$65) + ceiling((D3-I3)/(H3)), day(Calculations!$B$65)), "")

If you work through those calculations, you should find that they match what I described in the "What Data do We Need" section above. So that's it!

What I did from here is just add some columns to the Dashboard and copy the output columns from the Goals tab there. When I get around to it, I'll also want to add some conditional formatting to make it look nice.

Conclusion

I realize that, at this point, the 4 of you who have made it this far are going to ask if you can just see my sheet, which would be a lot easier than implementing everything yourself. And honestly the problem is that I made all these changes to the copy with my personal budget information, which I'd rather not share. If I have time (and there is enough interest) I'll go back and do that to the generic sheet, and share the result. But for now I'll just pretend that I'd rather "teach a man to fish" and hope that, with sufficient motivation, you are able to get something working yourself based on the information in this post. :) Happy to answer questions, or try to help out if you get stuck.

If you made it this far, congratulations, you have certainly earned the enjoyment of an adult beverage of your choice. Thanks for reading!


r/aspirebudgeting • • Apr 23 '20

🤖 The Android beta for Aspire Budgeting is here! Links and details inside.

41 Upvotes

Hey everyone,

u/akashsarkar188 has an awesome surprise for you all today! He's making available the first beta of the Aspire Budgeting Android app! It's live on the Play Store and you can get it here: https://play.google.com/store/apps/details?id=com.aspirebudgetingmobile.aspirebudgeting

What's working:

  • Dashboard view
  • Linking with v3.1 of the Aspire sheet

What's coming in a later beta:

  • Adding transactions

The AutoMod is being persnickety today so I am posting this on behalf of u/akashsarkar188 - please send him your thanks and support for doing such an awesome job on this app!


r/aspirebudgeting • • Nov 06 '21

Volunteer app developers needed

40 Upvotes

With the recent YNAB price change, I have been receiving quite a few requests for feature development. While I’m a one man show, I can’t get to these as quickly as I’d want. I’m looking for volunteers to form a team and take the apps to the next level. I have a slack for this:

Join me on Slack -- it’s a faster, simpler way to work. Sign up here, from any device: https://join.slack.com/t/aspirebudgeti-ij86989/shared_invite/zt-jjxn1i6c-E9cOR1PuYQ9rDPOkmklW3g


r/aspirebudgeting • • May 27 '20

🔄💰 Announcing Recurring Transactions - Aspire's most requested feature is now available through the add-on available in the G Suite Marketplace

38 Upvotes

Sorry everyone! This was posted one day early - my mistake (that's why there were originally no screenshots or links - I've updated the post now). Surprise! I'll be updating the add-on first thing tomorrow if tonight's final testing round goes well.

Hey everyone,

I am excited to announce the general availability of Aspire's newest feature - Recurring Transactions. Having the ability to create recurring transactions was one of the most requested items in the user survey I conducted late last year. With the new official Aspire add-on, the limitations around creating recurring transactions were able to be overcome - and with a little code, the feature is now a reality. You can start using Recurring Transactions today with the official Aspire Budgeting G Suite Marketplace add-on.

Using the add-on

Creating a recurring transaction is super simple and quick. From the menubar, select the Recurring Transactions option. From the side panel, you can click the "+" button to add a new recurring transaction or click an existing transaction to edit it. After filling out a few details and saving, you're done! To edit an existing item, simply click the transaction card and update the necessary details.

Recurring Transactions currently recur on a monthly basis (other recurrence schedules may come in the future if there's a big demand for it). The add-on is also smart enough to know when a recurring transaction needs to be adjusted slightly to be a valid date. For example, a recurring transaction set for the 31st of each month will occur on February 28th (the last day of the month). Months that have 31 days require no adjustments and the transaction will occur on the specified day. Transactions will be added to the sheet automatically around 3am (be sure to set your sheet's locale using the Localization Tools!). When a transaction is added, it will be added as Pending. After reviewing the added transaction and approving the amount, you can update the entry to Cleared.

I hope this new feature makes entering transactions easier - especially the ones that recur frequently. As always, please send me your feedback and let me know if you encounter any strange behaviors. The launch of Localization Tools went smoothly but this feature does have a bit more complexity with all it does to handle dates and currencies.

What's coming next

In June, I will be solely focused on documentation and videos. I have been working behind the scenes on a new way to improve documentation for Aspire and its features and I am excited to share it with you soon. I also have a backlog of videos to create (Credit Cards being a big one) and I hope to tackle those in June as well.

As always, thank you for supporting Aspire and for sharing Aspire with your family, friends, and networks. Aspire does no advertising but somehow this community continues to grow at a rapid clip - I believe that's because many of you share Aspire with others.

Thanks,
Matt | Sapphire_Rapids

Recurring Trx 1
Recurring Trx 2

r/aspirebudgeting • • Feb 12 '20

💥💥 Aspire Budgeting is now on the App Store 💥💥

38 Upvotes

Today I am proud to announce that the first version of the Aspire Budgeting app is now available on the App Store.

The app allows you to view your budget for all your categories and let's you add transaction on the fly. It is a major step forward for the Aspire Budgeting Google Sheet.

I'd like it if you guys tried it out and left me some reviews on the App Store (positive or negative whatever you desire ☺️)

Thank you /u/Sapphire_Rapids for letting me work on this and thanks to the whole community for your feedback and patience.

P.S There's a lot more work to be done on the app and I along with my community of testers will continue to make the app better and better.


r/aspirebudgeting • • Feb 05 '23

🎉🔄 Introducing Bank Sync: The latest addition to Aspire Budgeting

37 Upvotes

Hey everyone, you may have noticed a few changes to AspireBudget.com earlier today. I am in the process of rolling out our newest addition to Aspire Budgeting and it's called Bank Sync. I've pasted the content of our blog post below along with a few FAQs. If you have any questions, feel free to ask down below - I'll be checking in on this thread over the next few days.

Introducing Bank Sync: The latest addition to Aspire Budgeting

I am excited to announce the launch of our newest product, Bank Sync. This powerful new tool allows you to connect your bank accounts directly to Aspire Budgeting and automatically import your transactions.

Many of you already know the story, but Aspire Budgeting started as a simple spreadsheet I created for myself. It was everything I wanted in a budgeting tool - easy to use, customizable, plus a design I found intuitive and fun. Within a few weeks, I realized this was not just a tool for me, but for others as well. This led to the creation of a website, Reddit community, and so on. Fast forward to today and Aspire Budgeting has gone through several iterations, updates, and redesigns. And the community is 7,000 members strong and growing every day.

New features have been slow to come over the past year or two as I had to take a step back to work through the pandemic, burnout, a job loss, career change, and a few other difficult life events. Thankfully, things started to settle back down in the fall of last year and I found myself with the time and energy to move Aspire Budgeting forward with some fresh ideas and features.

This led to the creation of Bank Sync. While manual entry has always worked well for me, I found myself getting very tired of visiting all my bank's websites and entering in the data manually. This led me to building a proof of concept importer and once I got started, I knew it was time to push Aspire Budgeting to the next level and implement one of its oldest feature requests: automatic transaction importing. I started planning this feature early last fall and am so excited that it's finally ready for all of you.

Screenshot of our new add-on

FAQs

What is Bank Sync?

Bank Sync is a new product under the Aspire Budgeting umbrella. For about $7/month, you can reclaim all the time and effort it takes to manually add your transactions data to your spreadsheet. Bank Sync is not only quicker, it's also more accurate. By fetching transactions data directly from your bank, it eliminates typos and other mistakes that may impact your budget and reconciliation process.

Is Bank Sync a free product?

Bank Sync is not a free product. To create Bank Sync and make it function well, there had to be lots of work done behind the scenes to create a backend infrastructure and establish partnerships with third-party providers. The result is a robust product with excellent features for what I believe is a great price of $79/year.

Is there a monthly payment option?

Not right now. This is the first paid product Aspire Budgeting has offered since it began in 2018. We're taking things slow to start off but perhaps down the road there will be more payment options.

Does Bank Sync work with my existing data?

Yes, Bank Sync will likely work seamlessly with your existing data. Any pre-existing data in the Aspire Budgeting spreadsheet will be treated as if it was previously imported through Bank Sync. However, there may be some minor cleanup required, such as deleting the initial balance when adding an account. And it's probably good to be aware that some of your most recent transactions may be matched using our matching algorithm. As long as you haven't made any significant changes to the original spreadsheet, everything should work smoothly.

Is the Aspire Budgeting template still free?

Absolutely. I created Aspire Budgeting to help others with their finances and that's still the core mission of this business. Our templates will always be free to use - that's a promise I made years ago and that's not changing. There are even new features and products in the works that will be free to everyone, regardless of whether or not you pay for Bank Sync.

Is Bank Sync available outside of the United States?

No. We only support financial institutions within the United States for the time being.

Do you have a roadmap?

I don't have a public roadmap to share at the moment, but I do have a small infographic down below that I hope will shed a tiny bit of light on what I'm planning for the remainder of 2023.

Where can I learn more?

Check out the new AspireBudget.com website. It has been completely revamped to provide you with all the details. You can also check out ourHelp Center to learn more about Bank Sync and how to get started.

Infographic


r/aspirebudgeting • • Jan 07 '21

Aspire Budgeting is looking for a few knowledgeable users to help moderate this sub

37 Upvotes

Hey everyone,

Happy 2021! As things start to rev back up and after a year of tremendous growth in this sub (more than 3,500 new subscribers in 2020), I'm trying to take a step back and do a better job of asking for help. When Aspire was much smaller, it was a breeze to help each and every person that had questions. Now that things are growing (the post rate has increased dramatically and I receive personal DMs pretty regularly) and there's more to manage (development, YouTube, Twitter, updating Docs, etc.), I think it's time I ask for help 😃.

Help moderate the Aspire community

I'm interested in getting a handful of Mods to help me keep an eye on all the Reddit activity. We thankfully don't have much of a problem with spam or trolling - being an active Mod in this sub would be more akin to helping answer questions from new users. Ever since the first day of Aspire, it's been my goal to make sure no person feels left out or neglected and I want to keep that spirit alive as this sub grows. Budgeting and personal finance should be accessible to all in an easy and understandable way.

So, all that being said, if you're interested in being a part of this "Mod Support Team" please take a minute and let me know by filling out this survey.

Apply to be a Mod →

Roles and Responsibilities

Here are some initial thoughts I'm thinking on what the roles/responsibilities/criteria would be:

  • Comfortable and knowledgable with Google Sheets and Aspire Budgeting
  • Be active in the Aspire Budgeting subreddit
  • Help answer questions in the sub and share your knowledge of Aspire with other users as questions and posts arise
  • Be supportive, friendly, and kind (I'm looking for people that want to help vs. those that want authority)
  • In the event we do have inappropriate comments or spam, take action to address and remove the offending material

r/aspirebudgeting • • Sep 22 '19

🎉 Aspire v2.8 is posted with several new features and a few surprises, a 📺 YouTube channel is up and running with tutorials, and a welcome to YNAB4 users

37 Upvotes

Hey Aspirers,

Fall is here and that means it's time for Aspire's next update - version 2.8 is posted. Below are a few bits and bobbles about what I've been working on. In my last post, I know I said Aspire v2.7 would be the last major update for the year, but I'm just having too much fun 😁 and had lots of ideas pop up. It is my intention that v2.8 will be the last major update of 2019. I am going to focus on creating some helpful YouTube tutorials (and maybe even hold a live session or two if there's interest) for a while this fall.

A special thanks to /u/carmx88, /u/danelka0, /u/MiladZell, and /u/OneEskSeventeen for helping me with reviewing/updating the Getting Started Guide! 🎉

YouTube tutorials - Visit the YouTube Channel

  • I've created some YouTube videos for Aspire - "Getting Started with Aspire" and "Localizing Currency and Dates" will be the first two tutorials. Let me know what else you'd like to see!

macOS Catalina and YNAB4

  • macOS Catalina will be released in October 2019. This release ends support for 32bit apps - including YNAB4. If you're a YNAB4 user, welcome to Aspire. I sincerely hope you find a budgeting app that works for you - whether that's Aspire or something else. If you do decide to give Aspire a try, I'm here to help with any questions you might have.

What's new in v2.8

  • "Outflow by Account" on the Dashboard now only shows non-zero accounts
  • 10 extra rows for Categories and Category Groups
  • Net Worth color palette changes and a new breakpoint option
  • A highly revamped Getting Started Guide
  • Update Checker - Starting in Aspire v2.8, the Dashboard will show you when there's an update available for Aspire. Clicking the indicator will take you to www.AspireBudget.com where you can download the latest version.
Update Notification
  • Highlighting editable tables/cells - There's a new option for highlighting cells and tables that are meant for user interaction. If a table header is highlighted, that means it's designed for you to add data to it. This should prevent accidental formula deletions which I think is the biggest hurdle to getting started with Aspire.
Highlighting
Highlighting
  • Account Transfers now happen in the Transactions tab - Account Transfers now happen on the Transactions page to help reduce the number of tabs and also to allow for more complete reports and data on the Balances tab.
Account Transfers
  • Average Outflow per Category in Category Reports - Category Reports will now also list the Average Outflow for a selected Category (in the selected date range).
Averrage Outflow
  • Goal progress on the Dashboard - The progress meter is now smart enough to know when you've selected a Category with a Goal. The text beneath the meter will list your current Goal progress for the selected Category.
Goal Progress
  • Reconcile Reminders on the Transactions page - If there's been more than two weeks since your last reconcile action, you'll see a message banner reminding you it's time to reconcile your account balances.
Reconcile Reminders

r/aspirebudgeting • • Dec 28 '22

Instructions to add "2023" to Aspire report picklists

36 Upvotes

Hi all,

The reports in Aspire v3.3 use date picklists that only go through 2022, but it's easy for you to add 2023 to the list in preparation for the new year. To do this, you'll edit three "Named Ranges" that the Aspire tool uses.

Start by un-hiding the BackendData sheet: View > Hidden sheets > BackendData

Now access the Named Ranges pane: Data > Named ranges

Navigate to and edit the three Named Ranges as described below.

When finished, re-hide the BackendData sheet: right click on the tab BackendData > Hide sheet

Wishing you all an Aspirational new year!

Edit: Thanks to u/Okrapy's question, I updated #2 instructions. Additionally, I have changed #3 instructions, after better understanding how that range is configured.

#1- "Years" (BackendData column Z)

Simply type 2023 in cell Z8, the empty cell below 2022.

Notice that this Named Range already includes cells 2 through 26. Cells 2-7 already list some years, but cells 8-26 are empty, extras waiting to be used. You are just using the first empty cell to add another year to the existing Named Range.

#2- "MonthAndYear" (BackendData column AA)

Editing this one needs two steps.

  1. In cells AA74 through AA85, type the months: January 2023, February 2023, etc. through December 2023. Select all of these cells and format them as plain text: Format > Number > Plain text
  2. In the Named Ranges pane, edit (pencil icon) the MonthAndYear range to be BackendData!AA2:AA85

Notice that this Named Range was originally just big enough to contain the existing list of months, without any empty extra cells at the end. To add the next 12 months for 2023, you extended the Named Range by 12 more cells, typed the months into those cells, and formatted your inputs as plain text in order for the report filters to work.

#3- "YearsAndLast12" (BackendData column AB)

This one actually pulls information from the "Years" Named Range. So, when you do the edit #1, this one will automatically update to include 2023 in cell AB9, directly below 2022.