Renewing the City Business License: Difference between revisions
Jump to navigation
Jump to search
TJSomething (talk | contribs) (Fix SQL formatting) |
TJSomething (talk | contribs) (Format?) |
||
Line 6: | Line 6: | ||
#Run the following SQL query, with YYYY using the current year. | #Run the following SQL query, with YYYY using the current year. | ||
#:<pre>SELECT SUM(amount) FROM `payments` | #:<pre>SELECT SUM(amount) FROM `payments` | ||
: WHERE | |||
: date > '2022-10-01' AND | |||
: date < '2023-10-01' AND | |||
: status = 'Completed'</pre> | |||
#Enter the resulting amount under '''Gross Receipts'''. | #Enter the resulting amount under '''Gross Receipts'''. | ||
#Set the beginning date to 10/01/XXXX where XXXX is last year. | #Set the beginning date to 10/01/XXXX where XXXX is last year. |
Revision as of 21:11, 23 September 2023
- Open https://aca-prod.accela.com/ONE/Default.aspx in Chrome. The site just works in Chrome.
- Login with the account for [email protected].
- Open the Business Licensing and Events tabs.
- Click Renew License on the line with the most recent license that starts in "R".
- Click Add Gross Receipts.
- Run the following SQL query, with YYYY using the current year.
SELECT SUM(amount) FROM `payments`
- WHERE
- date > '2022-10-01' AND
- date < '2023-10-01' AND
- status = 'Completed'
- Enter the resulting amount under Gross Receipts.
- Set the beginning date to 10/01/XXXX where XXXX is last year.
- Click Continue Application.
- Click Continue Application.
- Click Check Out.
- Click Checkout.
- Enter the name of a checking account signer, the email `[email protected]`, their contact info, and Wells Fargo checking account info.
- Click Pay $XX.XX Now.
- Click Print receipt.
- Save that as a PDF.
- Click Continue.